topic Using parameter as slicer in DAX Commands and Tips

Using parameter as slicer

enavesca — Mon, 01 Apr 2024 18:12:35 GMT

I’ve created the scatter chat below based on “SIZE” and “SCORE” metrics:

Size = CALCULATE(DIVIDE(SUM((table[Size_number])),COUNTROWS(table)))

Score = SUM(table[New_value])

Additionally, I create a parameter (slicer) through the option to considerer 4 measures (Big Bet, Incremental, Money Pit and Quick Win)

Parameter = {

("Big Bets", NAMEOF('Measure'[BB]), 0),

("Incremental", NAMEOF('Measure'[IN]), 1),

("Money Pit", NAMEOF('Measure'[MP]), 2),

("Quick Win", NAMEOF('Measure'[QW]), 3)

}

Measures:

BB = IF([Size]>3&&[Score]>72,"Big Bets","")

IN = IF([Size]<=3&&[Score]<=72,"Incremental","")

MP = IF([Size]>3&&[Score]<72,"Money Pit","")

QW = IF([Size]<=3&&[Score]>=72,"Quick Win","")

At the end, I want to filter the 'INITIATIVE' using a parameter as a slicer. However, I am not sure how to link the parameter to the graph. I believe there might be a missing link between them.

I appreciate any contribution to solve this issue.

Thanks

Re: Using parameter as slicer

lbendlin — Mon, 01 Apr 2024 20:50:06 GMT

Those seem to be unrelated things. Your quadrants should always be present on the chart, so your filter would be more like a highlighter?

Re: Using parameter as slicer

enavesca — Tue, 02 Apr 2024 03:01:41 GMT

you are right. The quadrants will be always there, however, I want to present only those selected from the slicer.

Re: Using parameter as slicer

lbendlin — Tue, 02 Apr 2024 19:39:32 GMT

Go with the highlighter, don't waste your time on the filter.