March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to Solution.
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.
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.
if you are using a matrix, it is preferable to use isinscope() function .
isinscope mainly task iis to control the calculation of a matrix base on the level you are on .
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
85 | |
79 | |
64 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |