cancel
Showing results for
Did you mean:
Frequent Visitor

## how to display Measures in Matrix Subtotal

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?

1 ACCEPTED SOLUTION
Microsoft

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.

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Frequent Visitor

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)

Microsoft

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.

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Done, using "Sum" has solved the problem.

Microsoft

Hi @Shoukry,

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User IV

See if this helps:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Announcements