Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
I have a task where I need to dynamically switch to measure for a visual.
E.g. I have Measure1 and Measure 2 and country and category filter.
By default as initially there will be no value selected in country or in category filter the visual should show data using measure1
If user select any value from country or category filter the visual should use measure 2.
NOTE: My data is coming proper with measure1 and measure2 Only help I need is switching among these 2 measure's
I tried this measure:
1. switch(True(), SELECTEDVALUE(PA_MKT_CATE_OARP[country])<>Blank(),[Selected Caountry_categ],SELECTEDVALUE(PA_MKT_CATE_OARP[country])=BLANK(),[Total country_categ])
2. if(SELECTEDVALUE(PA_MKT_CATE_OARP[country])<>BLANK() || SELECTEDVALUE(PA_MKT_CATE_OARP[category])<>BLANK(),[Selected Caountry_categ],[Total country_categ])
But output is not coming correctly.
Kindly help me with the dax formula if possible.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
you are probably looking for HASONEVALUE().
Also consider using Field parameters or Calculation Groups.