Forum Discussion

cruncher's avatar
cruncher
Icon for Helper II rankHelper II
1 year ago
Solved

Dax Switch Calculation not working as expected

My Dax calculation is behaving weird. Something related to evaluation context but couldn't able to understand.   This is sample data. In my data there are 3 rows and two columns (Region and Country...
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    Hi cruncher 

    Thank you for the follow-up questions.

    Since this has already been implemented using Field Parameters but is not filtering dynamically, I would recommend submitting this scenario as a feature request in the official Power BI Ideas forum.

    The Product Team actively reviews suggestions there, and if others in the community upvote it, it may be considered for future updates.

    https://ideas.fabric.microsoft.com/

    I trust this information proves useful. If it does, kindly “Accept as solution” and give it a 'Kudos' to help others locate it easily.
    Thank you.

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

Hi cruncher ,
Thanks for your follow-up and for pointing that out.

You're absolutely right — the earlier version of the logic using SELECTEDVALUE would return blank when multiple countries exist, which is why the visual appeared empty for the North region.

To address this, I’ve updated the measure to dynamically handle both cases:
DAX:

RegionOrCountryDisplay_v5 =
VAR DistinctCountryCount =
    CALCULATE (
        DISTINCTCOUNT ( 'SalesData'[Country] ),
        ALLEXCEPT ( 'SalesData', SalesData[Region] )
    )
RETURN
    IF (
        DistinctCountryCount = 1,
        MAX ( SalesData[Region] ),
        CONCATENATEX ( VALUES ( 'SalesData'[Country] ), 'SalesData'[Country], ", " )
    )
    For South selection                                                                            For North selection with multiple countries 

I've uploaded the updated PBIX file here for your reference.

Please feel free to review it and let me know if there's anything else needed from my side. I’d be happy to assist further to help resolve the issue.

If this post helped resolve your issue, please consider giving it Kudos and marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.