Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Slicer default value

Hi good day, Pls need help on how to set the default value on my card if non selected on my slicer, all data is in one table only. Please refer below link. what they required is the green column to ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi AllanBerces ,

    Based on the testing, try using the following dax formula.

    DefaultValue = 
var _selected = SELECTEDVALUE('EAST AND WEST'[E&W])
RETURN
IF(
    ISBLANK(_selected),
    CALCULATE(SUM('TRS'[Overall_PT_YTD])),
    CALCULATE(SUM('TRS'[SUM_PT_by_AREA]), 'TRS'[AREA] = SELECTEDVALUE('EAST AND WEST'[E&W]))
)

    Then, drag the measure to the card visual.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AllanBerces ,

Based on the testing, try using the following dax formula.

DefaultValue = 
var _selected = SELECTEDVALUE('EAST AND WEST'[E&W])
RETURN
IF(
    ISBLANK(_selected),
    CALCULATE(SUM('TRS'[Overall_PT_YTD])),
    CALCULATE(SUM('TRS'[SUM_PT_by_AREA]), 'TRS'[AREA] = SELECTEDVALUE('EAST AND WEST'[E&W]))
)

Then, drag the measure to the card visual.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AllanBerces's avatar
    AllanBerces
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    Hi Tutu_in_YYC thank you very much for the reply, I change some paremeter on my data and follow your instruction. and work perfectly.