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_Quote...
Need Help
  • JemmaD's avatar
    JemmaD
    2 years ago

    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.

JemmaD's avatar
JemmaD
Helper V
2 years ago

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.

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    JemmaD 

    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 . 

     

     

    https://dax.guide/isinscope/