Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |