Forum Discussion
Distinct Count does not Match Total Displayed in Filter
Experts, Please help! I have a measure that DISTINCTCOUNTS a column and displays it as a Total Per Country. However, when I look at my visual filters, the count/total does not match. Ex. Afghan...
Hi,
I understand that. My issue is, I am doing a distinct count on ID from the FactTable, which is linked by CountryID to the DimTable.
In the FactTable, for example, there were 100 non-unique IDs under CountryID 4 - Australia. When I DISTINCTCOUNT IDs for Australia, it became 50. However in the filter visual, it is showing 6.
And yes, I did just drag the Country field, but the filter visual is still displaying the count wrong =(