Hi , I have a measure Rank for "Major expense type = RANKX(ALLSELECTED('Concur Data Sheet'[Major Expense Type]),CALCULATE(SUM('Concur Data Sheet'[Approved Amount (rpt)])),,DESC,Dense) "
This when trying to add as a Visual filter to a KPI Card would not work .
Hi @lravikiran ,
The measure in the KPI measure is always equal to 1. So you cannot filter the visual based on the measure. I recomend you to create a calculted column to get the rank value to work around.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!