Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
CAT1 | CAT2 | VAR1 |
A1 | B1 | 0.25 |
A1 | B2 | 0.75 |
A1 | B2 | 0.5 |
A2 | B2 | 0.25 |
A2 | B2 | 0.5 |
Desired outcome:
B1 | B2 | Total | |
A1 | .25 (1) | 1.25 (2) | 1.5 (3) |
A2 | .75 (2) | .75 (2) | |
Total | .25 (1) | 2 (4) | 2.25 (5) |
Thanks for the help!
Solved! Go to Solution.
Hi , @Anonymous
I think you just need to drag field "var1" into the value of the matrix again and then change the type to " count"
Best Regards,
Community Support Team _ Eason
Hi , @Anonymous
I think you just need to drag field "var1" into the value of the matrix again and then change the type to " count"
Best Regards,
Community Support Team _ Eason
@Anonymous - This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Seems like you are headed down this track. You might try using ISINSCOPE instead of HASONEVALUE. Hard to say without knowing the measure formula. (hint)