Hi all,
I have a table of data that I created a dynamic ranking measure for as follows:
dynamicrankmeasure = RANKX(ALLSELECTED('Table'), CALCULATE(SUM('Table'[Sales]),,DESC,Dense)
...which essentially ranks the items in the table according to their sales figures, and adjusts when filters are applied to always show a neat ranking sequence from 1 to whatever.
I did this in order to create a 'Top X %' slider which can be moved by the user from 0% to 100%. So when 50% is selected, only the top 50% of entries (by sales figure) are shown in the table. Here's the additional measure I created for this:
topxpercfilter = IF([dynamicrankmeasure] <= DIVIDE('Top % By Sales Value'[Top % By Sales Value],100) * COUNTROWS(ALLSELECTED('Table')), 1, 0)
Where the 'Top % by Sales Value' is a 'what if?' parameter running from 0% to 100%.
I added the measure topxpercfilter as a 'visual level filter' on the table for the slider to work (setting it to only show entries where topxpercfilter is not equal to 0). The issue is, I have a separate KPI section (multi-row card) which summarises values in certain columns. But whatever is selected on the slider, the KPI section doesn't update (it's fixed at the values for the top 100%).
Is there a way I can configure this so that the KPI section can adjust according to what's shown in the table?
Thank you very much in advance for any help you can provide!
Ben
