Forum Discussion
Solved
Remove RANKX from Total Row and Hide from Non Related Filters
Hello everyone, I have the few Created Measures in my Database: - StoreRank = RANKX(ALL(Table[Store Code],Table[Store Name]),CALCULATE(SUM(Table[Sales Volume])),,DESC) - ProductRank = RA...
For your first question, you can use HASONEFILTER to detect totals/subtotals
Something like this
- StoreRank = IF ( HASONEFILTER ( Table[Store Code] ), RANKX ( ALL ( Table[Store Code], Table[Store Name] ), CALCULATE ( SUM ( Table[Sales Volume] ) ), , DESC ) )
Did I ask something not logical to do in Power BI ?
For your first question, you can use HASONEFILTER to detect totals/subtotals
Something like this
- StoreRank =
IF (
HASONEFILTER ( Table[Store Code] ),
RANKX (
ALL ( Table[Store Code], Table[Store Name] ),
CALCULATE ( SUM ( Table[Sales Volume] ) ),
,
DESC
)
)
can you help me on another issue please ?