Use Measures as a Slicer

Hi mkane12  ,
Thanks for reaching out to the Microsoft fabric community forum.

Measures

New measure and create the following measures:

Measure 1: Losses

Losses = 
CALCULATE(
    SUM(McLeodIQ_Operations[Projected Carrier Margin]),
    McLeodIQ_Operations[Win//Loss] = "1"
)

Measure 2: Loss Vol

Loss Vol = 
CALCULATE(
    SUM(McLeodIQ_Operations[Volume]),
    McLeodIQ_Operations[Win//Loss] = "1"
)

Create a Disconnected Table for Measure Selection

New table and create:

MeasureSelector = DATATABLE(
    "MeasureName", STRING,
    {
        {"Losses"},
        {"Loss Vol"}
    }
)

This table has no relationship with your main data table , it’s just for the slicer.

Create a Dynamic Measure

Create a new measure named Selected Measure :

Selected Measure = 
VAR Selected = SELECTEDVALUE(MeasureSelector[MeasureName])
RETURN
    SWITCH(
        Selected,
        "Losses", [Losses],
        "Loss Vol", [Loss Vol],
        BLANK()
    )

Build the Visuals

1. Go to Insert > Map visual.

2. Drag McLeodIQ_Operations[ State ] to Location.

3. Drag SelectedMeasue to Size or Tooltips depending on how you want it visualized.

4. Add a Slicer to the canvas.

5. Use MeasureSelector[ MeasureName ] in the slicer.

Test It

Select "Losses" or "Loss Vol" in the slicer.

The map visual will update accordingly, reflecting the selected measure per state.

Please find the attached pbix for reference

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team