apply filter to temporary table in measure

[JMac_WandB]

Hi Team,

I'm hoping that there is a simple solution to this. I have a table of calculated measures. Put simply I need to count the number of rows where one measure (e.g. the up benchmark) is > 100%. I have tried a number of different approaches (addcollumns + summarizecolumns) but the result is returning all rows (128) rather than the filtered outcome?

Can anyone suggest where I may be going wrong here?

Appreciate any help!

Up_Cnt4 =

VAR _tmptable =

SUMMARIZECOLUMNS(LIC_Price_NTA[Cal_Period],

"Up", [Up_Returns_Benchmark])

RETURN

CALCULATE(COUNTROWS(_tmptable), FILTER( _tmptable, [Up] > 1))

[amitchandak · Accepted solution]

@JMac_WandB , Try a measure like

Countx(filter(ADDCOLUMNS( Summarize(LIC_Price_NTA[Cal_Period]) ,"Up", [Up_Returns_Benchmark]), [_1] >1), [Cal_Period])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[JMac_WandB]

Thanks Amit, perfect (just needed to alter the [_1] to [up])

Really appreciate your quick response.