subtotals not working with 3 in One measure

[djemy1975]

Hi colleagues,

I have a combined measure made of 3 measures :PR, PO ,Spending. This measure is called All measures I put a slicer to filter by Measure on matrix visual .all is working ,but subtotals do not give the correct subtotals .is there any workaround to solve this problem?

Thanks in advance,

 

[Matt Allington]

What is your formula for Selected measure? Max() something? If so, that is why you are getting spending. There are various ways to fix it. You could change selected measure to SELECTEDVALUE() and the use an IF

IF(isblank([selected measure]),[spend] + [po] + [pr],what you have already goes here)

 

[djemy1975]

What is your formula for Selected measure? Max() something? If so, that is why you are getting spending. There are various ways to fix it. You could change selected measure to SELECTEDVALUE() and the use an IF

IF(isblank([selected measure]),[spend] + [po] + [pr],what you have already goes here)

First , I want to thank you for your reply;

My formula for selected measure is:
Selected Measure = SELECTEDVALUE('Measure Selection'[Order];1)
I have a table of measures called :"Measure Selection" ,with two columns :"Measure Name" and "Order" , from which I select the measure name using Slicer

"Measure Name" column: "Order" Column:
Spending KDZD 1
PO 2
PR 3

I think the problem is in the '[Order];1)

Best regards,

 

[Matt Allington]

Your measure
Selected Measure = SELECTEDVALUE('Measure Selection'[Order];1)

Is hardcoding the value 1 in the case that there is more than 1 value available.
When you are in the Total, there is more than 1 value available - by definition.
So you have hard coded your total to be [Spending].
Change your measure to this

Selected Measure = SELECTEDVALUE('Measure Selection'[Order];[spend] + [po] + [pr])
You need to add the correct names of the measures

 

[djemy1975]

Your measure
Selected Measure = SELECTEDVALUE('Measure Selection'[Order];1)

Is hardcoding the value 1 in the case that there is more than 1 value available.
When you are in the Total, there is more than 1 value available - by definition.
So you have hard coded your total to be [Spending].
Change your measure to this

Selected Measure = SELECTEDVALUE('Measure Selection'[Order];[spend] + [po] + [pr])
You need to add the correct names of the measures

Thank you so much .I adjusted the formula as you suggested and it is ok

Mark thread as SOLVED