Forum Discussion
Helper IIIDistinct Filter not giving the result expected
Below is my issue when I do distinctcount on 'assetnum' the total is 4145, but when I seperate them by filter BM/CM the count total is 2020+2425 which is 4445 which doesnt match with 4145.
I did exported and checked the 4145 for some reason its excluding the worktype = 'BM','CM' filter not sure why.
amitchandak lbendlin could you please help, appreciate it
I think you can achieve your goal with the 'Visual Calculations'.
Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
7 Replies
- mickey64
Super User
I don't know your detailed data, so I'll explain with a simple data example.
In the table below, if you run "DISTINCTCOUNT" on just "BM", the result will be "4".
Also, if you run "DISTINCTCOUNT" on just "CM", the result will be "3", and the sum of these is "7" (=4+3).
But if you run "DISTINCTCOUNT" on "BM&CM", the result will be "6". This is because there is duplicate "Assetnum" data, as marked in yellow in the table.- mickey64
I think you can achieve your goal with the 'Visual Calculations'.
Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn
