Forum Discussion
Solved
Virtual table referencing in measures
Hello everyone, I am trying to get a KPI for BIAS which will allow me to count the number of rows at a summarized level which fall into a range. The best idea I've had is to create a summariz...
Yes, I do it all the time, but your code would be:
GreenBars = VAR SumTable = SUMMARIZECOLUMNS( 'Table'[Year], 'Table'[Period], "BIAS", CALCULATE( [BIAS Base] ) ) Return COUNTROWS(FILTER(SumTable, [BIAS] <= .05 && [BIAS] >= -.05))
Yes, I do it all the time, but your code would be:
GreenBars =
VAR SumTable =
SUMMARIZECOLUMNS(
'Table'[Year],
'Table'[Period],
"BIAS", CALCULATE( [BIAS Base] )
)
Return
COUNTROWS(FILTER(SumTable, [BIAS] <= .05 && [BIAS] >= -.05))
That does, the trick, thanks!