SWITCH with no values

[LD1]

Hi everyone, 

i would like to know how i can fix this formula please ? 

If in the table Agglo Commerciale'[Nom Strate Commerciale], I find "Monoprix" or "Carrefour so "RETAIL", If is blank "Créations digitales" else Agglo Commerciale'[Nom Strate Commerciale].

The formula I tried :

Mesure 2 = SWITCH(SELECTEDVALUE('Agglo Commerciale'[Nom Strate Commerciale],

"MONOPRIX", "RETAIL",

"CARREFOUR", "RETAIL",

ISBLANK(SELECTEDVALUE(Face[Produit]), "Créations digitales",

SELECTEDVALUE('Agglo Commerciale'[Nom Strate Commerciale]))))

Thank you so much !

Have a good day

[v-venuppu · Accepted solution]

Hi @LD1 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Greg_Deckler for the prompt response.

I have created corrected DAX measure using sample data to replicate the requirement.Please go through the attached PBIX file for your reference.

Thank you.

[LD1]

Hi @v-venuppu 

thank you for your response, it works ! But I think about it, do you think it's possible to create it with a new column in the dataset instead of calculation? 

Thank you,

[Greg_Deckler]

@LD1 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.