RANKX hierarchy with slicer

[jmenche]

Howdy,

I don't use PowerBI but I just started using the "add to data model" option in a pivottable and I am fiddling with DAX equations. I wrote a RANKX formula that works great...except it shows the rank for total when I filter for brand.

Total is just a column that has 'Total' for a value so I can put what is basically the grand total on top.

I have an ISFILTERED clause in for brand but the Total is filtered too. Is there a way that I can ignore the Total rank?

Thanks

Jeff

 

[JustynaMK]

Hi Jeff,

In your DAX formula, try replacing ISFILTERED with HASONEFILTER - this should tell the formula if it is performing the calculation for the "Total" or "Non-total" row.

 

[jmenche]

Thanks! I found a bunch of stuff online too. It never quite worked 100% but I got it to work 99% and can hide the rest