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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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