Hi All,
I was wrote following DAX formula to count distinct values present in a column. "=CountA(All(EmpTable[EmpName]))" but it gives error
Then I tried "=Countrows(All(EmpTable[EmpName]))" and it worked.
Can you make me understand why first formula didn't work? "ALL" function provided distinct values and "CountA" should have just counted resulted column. In Fact CountRows is also performing same calculation.
Thanks,
DJ
I was wrote following DAX formula to count distinct values present in a column. "=CountA(All(EmpTable[EmpName]))" but it gives error
Then I tried "=Countrows(All(EmpTable[EmpName]))" and it worked.
Can you make me understand why first formula didn't work? "ALL" function provided distinct values and "CountA" should have just counted resulted column. In Fact CountRows is also performing same calculation.
Thanks,
DJ