Forum Discussion
poojithas
Helper III
Helper IIIIncorrect Totals when using measure in table
Hi All, I am using a measure with the below formula in my table. When I use this measure in a table, I am getting incorrect totals. The expected total is 1164 but I get 1160. I tried using a...
Hi poojithas ,
When it comes to non-additive measures (DISTINCTCOUNT is one of them) there is no easy one solution fits all approach.
I recommend you the following post by sqlbi. There is loads to take away from it:
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
Hope this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/This is fixed using the below logic:
=sumx(values(locn),measure2)
poojithasHelper III
Helper IIIThis is fixed using the below logic:
=sumx(values(locn),measure2)