Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
Im strugleling with on of my measure in matrix viz, see the following measure :
I said right blank if the calculation is negativ or just do the calculation, but the grand total in matrix still the same, see the matrix result :
How can I force the right grand total ?
Thanks in advance for your advices.
BR
Julien
Solved! Go to Solution.
Hi,
Please check the below measure whether it suits your requirement.
V3 measure: =
SUMX ( DISTINCT ( calendartable[Mois] ), [total_days_billable_retreated_V2] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below measure whether it suits your requirement.
V3 measure: =
SUMX ( DISTINCT ( calendartable[Mois] ), [total_days_billable_retreated_V2] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |