How to use a what if parameter in my measure to filter top 20 products

[RogerSteinberg]

Hi,

I have a table thats showing top 20 products based on a calculated column flag that i have. I put that column in my visual level filter  to only show everything under 21.

Instead of using that visual level filter, I'd like to have a dynamic filter (what-if parameter) . For that i need to use that column from the what if parameter table within my measure to have it dynamic.

How can I do this using my current measure logic:

Currently my column is: 

test =

IF(

MIN('Table'[current_rank])<MIN('Table'[previous_rank]),

MIN('Table'[previous_rank])-MIN('Table'[current_rank]),

(MIN('Table'[current_rank])-MIN('Table'[previous_rank]))*-1

)

[Greg_Deckler · Accepted solution]

@RogerSteinberg - What-If parameters use a measure and measures cannot impact a calculated column because columns are calculated at the time of data load/refresh.

[amitchandak · Accepted solution]

@RogerSteinberg , whatif will not work dynamically for calculated columns

Refer this for measure

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[Greg_Deckler · Accepted solution]

@RogerSteinberg - What-If parameters use a measure and measures cannot impact a calculated column because columns are calculated at the time of data load/refresh.

[RogerSteinberg]

Hi,
I know.

I mentioned to "use in my measure".