Forum Discussion

ephramz's avatar
ephramz
Helper II
4 years ago
Solved

Help with project

I have a measure that calculates Arising*Delta, which results blank if no data. I want to create a new column in Table 2 called Status such if the measure Arising*Delta is a positive val...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    ephramz That's because you have some other measure that is returning a value so the row is going to get displayed. If you don't want that to happen you can basically take the same exact formula in a new measure that returns 1 or 0. So:

     

    Selector = 
  VAR __WhatToShow = SELECTEDVALUE('Table31a'[Column])
  VAR __Value = MAX([Arising]) * MAX([Delta])
RETURN
  SWITCH(__WhatToShow,
    "positive",IF(__Value>0,1,0),
    "negative",IF(__Value<0,1,0),
    "zero",IF(__Value=0,1,0),
    1
  )

     

    You use the Filter pane to filter on this measure is 1. This is called a Complex Selector. The Complex Selector - Microsoft Power BI Community

     

    I feel like I've solved 12 problems in one thread.

     

ephramz's avatar
ephramz
Helper II
4 years ago

I believe this measure works, but it does not relate back to the strategy and package, hence when i use this measure in the table visual, no value is shown Greg_Deckler 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

ephramz Not sure if that is the reason or if you just didn't have anything selected in your slicer. I modified this to be:

Measure to Show = 
  VAR __WhatToShow = SELECTEDVALUE('Table31a'[Column])
  VAR __Value = MAX([Arising]) * MAX([Delta])
RETURN
  SWITCH(__WhatToShow,
    "positive",IF(__Value>0,__Value,BLANK()),
    "negative",IF(__Value<0,__Value,BLANK()),
    "zero",IF(__Value=0,__Value,BLANK()),
    __Value
  )

You can substitute your measures for the aggregations of Arising and Delta. See Page 8 of attached PBIX below sig.

  • ephramz's avatar
    ephramz
    Helper II
    4 years ago


    In my table visual, when i press the slicer, it shows me the "negative" values. but it doesnt remvoe the rows that arent negative Greg_Deckler 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    ephramz That's because you have some other measure that is returning a value so the row is going to get displayed. If you don't want that to happen you can basically take the same exact formula in a new measure that returns 1 or 0. So:

     

    Selector = 
  VAR __WhatToShow = SELECTEDVALUE('Table31a'[Column])
  VAR __Value = MAX([Arising]) * MAX([Delta])
RETURN
  SWITCH(__WhatToShow,
    "positive",IF(__Value>0,1,0),
    "negative",IF(__Value<0,1,0),
    "zero",IF(__Value=0,1,0),
    1
  )

     

    You use the Filter pane to filter on this measure is 1. This is called a Complex Selector. The Complex Selector - Microsoft Power BI Community

     

    I feel like I've solved 12 problems in one thread.