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.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

ephramz Nope. You don't do that. You create an Enter Data query with these values for example:

Column

positive

negative

blank

zero

 

Then you create a measure like this:

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

 

 

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