Showing results for 
Search instead for 
Did you mean: 
lravikiran Regular Visitor
Regular Visitor

KPI Card not accepting Rankx measure at a visual level filter.

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 .


Need Help





Community Support Team
Community Support Team

Re: KPI Card not accepting Rankx measure at a visual level filter.

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.


Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 276 members 3,141 guests
Please welcome our newest community members: