how to display Measures in Matrix Subtotal

[Shoukry]

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?

[Shoukry]

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)

[v-jiascu-msft · Accepted 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

[Shoukry]

Done, using "Sum" has solved the problem.

[v-jiascu-msft]

Hi @Shoukry,

Could you please mark the proper answer as solution?

Best Regards,

Dale

[v-jiascu-msft]

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

[Greg_Deckler]

See if this helps:

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