Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ferhat_lyes
Frequent Visitor

DAX ERROR on format number

Hello Fellas, 

i have this DAX calculation to format display unit 

SWITCH( TRUE(),
SELECTEDVALUE(v_dim_produit[commodity_name]) = "ELEC", "#,0.00 €/MWh",
FILTERS(v_dim_produit[commodity_name]) in {"Charbon UE", "GAZ Peg", "Gaz TTC"}, "#,0.00 €/Baril",
"#,0.00€")

 

and i get these error for the second case of my switch() function : 

ferhat_lyes_0-1699008906812.png

 

Thanks in advance 😄 

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @ferhat_lyes ,

 

try the following

Measure = SWITCH( TRUE(),
SELECTEDVALUE(v_dim_produit[commodity_name]) = "ELEC", "#,0.00 €/MWh",
SELECTEDVALUE(v_dim_produit[commodity_name]) in {"Charbon UE", "GAZ Peg", "Gaz TTC"}, "#,0.00 €/Baril",
"#,0.00€")

 

Idrissshatila_1-1699009672805.png

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @ferhat_lyes ,

 

try the following

Measure = SWITCH( TRUE(),
SELECTEDVALUE(v_dim_produit[commodity_name]) = "ELEC", "#,0.00 €/MWh",
SELECTEDVALUE(v_dim_produit[commodity_name]) in {"Charbon UE", "GAZ Peg", "Gaz TTC"}, "#,0.00 €/Baril",
"#,0.00€")

 

Idrissshatila_1-1699009672805.png

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thank you too much 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.