Forum Discussion
Help with project
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 Try:
Column =
VAR __Package = 'Table2'[Package]
VAR __Arising = MAXX(FILTER('Table1',[Package] = __Package),[Arising])
VAR __Delta = MAXX(FILTER('Table1',[Package] = __Package),[Delta])
RETURN
IF(__Arising*__Delta <= 0,"Negative","Positive")
Hi is there another way to do it, because my powerbi report keep says "not enough memory" is there another way to optimize this ?
ephramz Maybe:
Column = VAR __Package = 'Table2'[Package] VAR __Arising = RELATED('Table1'[Arising]) VAR __Delta = RELATED('Table1'[Delta]) RETURN IF(__Arising*__Delta <= 0,"Negative","Positive")Greg_Deckler
the two tables are related by strategy and package (which are column values)
Arising is a measure and delta is also a measure.
And the (Arising*Delta) is the name of the measureephramz So do you want an actual calculated column or do you want a measure that is a column in a table visual? Because measures and calculated columns do not tend to mix very well most of the time.