Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Experts,
I need some help to understand why my column total (from measures) is wrong ?
TIA
Solved! Go to Solution.
Hi,
By default the total calculation applies your measure logic to itself. It seems you are using RANKX here?
To get around this issue you can create a new measure which has a custom logic for totals.
Example dax:
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi @Anjali_mm
There are 2 watys to correct total value:
1- Create a rank as a calculated column not a measure
2- Use if and add different formula for total (same as @ValtteriN solution)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi,
By default the total calculation applies your measure logic to itself. It seems you are using RANKX here?
To get around this issue you can create a new measure which has a custom logic for totals.
Example dax:
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
Proud to be a Super User!
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |