Forum Discussion
cglinn
5 years agoRegular Visitor
Aggregate a measure after Filtering
I'm very new to Power BI. I've read through many of the posts here but haven't been able to find a resolution, so hoping that someone can help. I'm trying to populate a single line Card Visual b...
PaulDBrown
5 years agoCommunity Champion
You could try:
Expected card total =
VAR _Variance = SUM(Table[Variance])
RETURN
CALCULATE(_Variance, FILTER(Table, _Variance < 0))