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
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 :
Thanks in advance 😄
Solved! Go to Solution.
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€")
Proud to be a 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€")
Proud to be a Super User! | |
Thank you too much
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |