topic Re: Dynamic Measure in Developer

Dynamic Measure

Afaque_Eclerx — Fri, 17 Mar 2023 04:40:03 GMT

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.

Re: Dynamic Measure

lbendlin — Sat, 18 Mar 2023 00:31:47 GMT

you are probably looking for HASONEVALUE().

Also consider using Field parameters or Calculation Groups.

Re: Dynamic Measure

Afaque_Eclerx — Sat, 18 Mar 2023 04:51:21 GMT

Kindly help me with the dax formula if possible.

Re: Dynamic Measure

lbendlin — Sat, 18 Mar 2023 11:22:30 GMT

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-p/963216
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