Menu
CoddyTech
Start learning

One Value or Many

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

SELECTEDVALUE(Column, alternate): the one value in the filter context, or the alternate.

Title = "Sales in " & SELECTEDVALUE(Stores[Country], "every country")

One country picked: its name. Several: "every country".

challenge icon

Challenge

Write Title: the text "Sales in " joined to the country, or "every country" when there is more than one. It is checked for each country 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