How to display a default value from a list of values

[Anonymous]

Hi,

Is there any way to get the default value to show from a set of values?

I am using Switch statemet, but it's not fetching me the exact result I am looking for.Kindly let me know if any more information

is required for anlysis.

Thanks,

Ravi

[Anonymous]

Hi @Anonymous,

>>I am using Switch statemet, but it's not fetching me the exact result I am looking for.Kindly let me know if any more information is required for anlysis.

Switch function contains the default value, you can write the default value at the end of the formula.

For example:

Measure:
Swith Statement = SWITCH(MAX(source[Value]),1,"first",2,"second","default")

Calculate column:
Swith Statement = SWITCH(source[Value],1,"first",2,"second","default")

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin,

Thanks for your update, Please find the below link for the actual issue that I am facing, hope this helps you for the understanding.

https://community.powerbi.com/t5/Desktop/Help-With-Formula-to-get-default-values/td-p/143600