Forum Discussion

JemmaD's avatar
JemmaD
Helper V
2 years ago
Solved

Display measure in Row Total only

Ok i'm trying again as I did not get any helpful responses to an earlier attempt at a solution

I have a measure called [Subs Demand] which uses the following DAX:

Subs Demand = 
VAR Referred_Quotes = CALCULATE ( [Quotes] , 'Quotes'[REFERAL] = "Referred" )
VAR _Tasks = CALCULATE ( [Tasks Total] , 'Task_Report'[Business Type] = "New Business" || 'Task_Report'[Business Type] = "Renewal" )

RETURN
_Tasks - Referred_Quotes

 I add this to a matrix which has Business Type in Rows (as new business or renewal) , REFERAL in Columns (as auto or referred), [Quotes] and [Subs Demand] in Values.

 

However [Subs Demand] is not split by REFERAL, only Business Type so I only want it to appear in the Row Total and not next to the [Quotes] measure which is split by both Business Type and REFERAL. 

 

This is a screenshot of my result, is there any DAX or method I can use to force the [Subs Demand] measure to only appear in the Row Total? Please help me with syntax!

 



  • Wow 30 views and no responses!

    I ended up using IF(ISFILTERED('Quotes'[REFERAL]), Blank(), [Measure] and it takes the values out. Then I can reduce the columns by disabling wrap text.

2 Replies

  • Wow 30 views and no responses!

    I ended up using IF(ISFILTERED('Quotes'[REFERAL]), Blank(), [Measure] and it takes the values out. Then I can reduce the columns by disabling wrap text.