Menu
CoddyTech
Start learning

Rows or the Total

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 22 of 24.

A rank shows 1 in the total row, which means nothing.

ISINSCOPE(Column) is true in rows grouped by that column, false in the total.

Rank Shown = IF(ISINSCOPE(Products[Category]), RANKX(ALL(Products[Category]), [Revenue]))

IF with no else gives blank in the total.

challenge icon

Challenge

Write Rank Shown: each category's rank by Revenue, blank in the total row. It is checked for each category and the total.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATEA Filter Replaces a FilterSeveral Filters at OnceKeeping FiltersRecap - Member Drink Sales

4DAX You Can Read

Variables with VARChoosing with SWITCHSWITCH(TRUE()) for RangesOne Value or ManyRows or the TotalChecking Copilot's DAXRecap - Sales by Price Band

2Removing Filters

ALL Removes FiltersPercent of TotalRemoving One FilterKeep One Filter: ALLEXCEPTShare of What Is ShownRecap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by RowAVERAGEX and MAXXFILTER Picks RowsMeasures Inside IteratorsRanking with RANKXRecap - Profit Without Columns