Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
3 | |
2 | |
2 |