Forum Discussion
JCK2
6 years agoHelper III
Dax column calculation
Hello, i want to create a measure to arrive at one number as how much is due in the month, I wrote teh below calculation in column, however this is not helping me achive what i want. How does...
- 6 years ago
JCK2 - Yep!
JCK2
6 years agoHelper III
Thanks a lot Greg!! Yes you are right...Spain should be over due....!
For the total due, instead of counting it as 1, if we use distinct count of the id's, we are there...currently this is the result..because 1 audit can be done at two places with same id and we want to calculate it as 1.
i did tried calculation to replace 1 by disntict count of ID's but no luck...:( still see the same numbers..
Greg_Deckler
6 years agoCommunity Champion
Let me take a look, I need to understand what you are asking.