Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI
I 'm using the Matrix Viulixationto to display some figures divided into Data Fields and Measure fields
the problem is some of this figures is Measures, so if I have one line in the Group Area, the Subtotal will display all columns without any problem, but
if I got more than one line in the Group Area, the Subtotal will display the data fields only but all Measures will not appear in the subtotal
does anybody know the reason for this problem?
Solved! Go to Solution.
Hi @Shoukry,
This could be the trick of math. The SELECTEDVALUE(Revenue_Report_V[TREVPAR_excl_OOO_MTD]) will return a BLANK value if the context is total or subtotal. Then blank divide anything will be blank. Please refer to Selectedvalue.
What's your expected value? How about SUM?
Best Regards,
Dale
Hello everybody
sorry for beging late,
I have reviewed the solution that provided by @Greg_Deckler. but I think it's talking about another problem
because my problem is I'm retrieving the measure value for each row without any problem but I can't make it visual in Subtotal of the Matrix control please check the below snapshot
also please check my Mesure syntax :
TREVPAR_excl_OOO_MTD_M = DIVIDE(SELECTEDVALUE(Revenue_Report_V[TREVPAR_excl_OOO_MTD]), [TY_EXrate_M],0)
Hi @Shoukry,
This could be the trick of math. The SELECTEDVALUE(Revenue_Report_V[TREVPAR_excl_OOO_MTD]) will return a BLANK value if the context is total or subtotal. Then blank divide anything will be blank. Please refer to Selectedvalue.
What's your expected value? How about SUM?
Best Regards,
Dale
Done, using "Sum" has solved the problem.
Hi @Shoukry,
Could you please mark the proper answer as solution?
Best Regards,
Dale
Hi @Shoukry,
Please try the solution by @Greg_Deckler. If you need more help, please provide the formulas of the measures. If you can provide the file, that would be great. A dummy file is enough.
Best Regards,
Dale
See if this helps:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |