Forum Discussion
Count Distinct Cumulative for Pareto
I have table like below: Year Month Region Product Item Value 2025 1 Asia Product A Item A1 100 2025 1 Asia Product A Item A2 100 2025 1 Asia Product A Item A3 20...
Your dax quite good but still not solved, since the table that i showed before is masked. my dax to distinct count is like below :
Count = CALCULATE(DISTINCTCOUNT(table1[item]),FILTER('table1','table1'[value] <> 0),FILTER('table1',NOT('table1'[market] = "abc" && 'table1'[Product] = "Product B")))
so i got miss result like this
Region Count Pareto
Eropa 124 0.84
Asia 18 0.96
so i got miss result like this
Region Count Pareto
Eropa 124 0.84
Asia 18 0.96
America 5 0.99
Africa 3 1.01
total pareto is over 100 percent and the calculation pct sligthly wrong.
i think we should change this part, cuz my count using some kind of filters
total pareto is over 100 percent and the calculation pct sligthly wrong.
i think we should change this part, cuz my count using some kind of filters
VAR __AllSelectedSalesCount = CALCULATE( [Sales Count] , __AllSelectedReg)
is the issue not how you are using distinct count?
the Distinct part is only checking for distinctness within the current row context (for example the current region) but when you are looking at a cumulative value there the context is across all regions.
See below where I redfined salescount using distinctcount, particularly notice that the total for sales count is 10 despite the individual values when summed being higher than 10