Forum Discussion
Calculated measure for conditional formatting returns inconsistent values.
Hi
I am using the Aug-22 version.
Problem was with the values stored in the variables. I rounded off all the variable values and the issue is finally resolved.
Thanks for your response though as no one else responded.
Regards.
Hi， egorlinus
Can you share a sample pbix for research?
Please try juxtaposing multiple cases in a switch function using "||".
Color subtotal =
var ..........
RETURN
SWITCH (
TRUE (),
AND ( ( _selection = "05C" ), ( _commissioning <= _main_sor ) )
|| AND ( ( _selection = "06D" ), ( _documentation <= _main_sor ) )
|| AND ( ( _selection = "07S" ), ( _safety <= _laying ) )
|| AND ( ( _selection = "08B" ), ( _barricading <= 2 * _laying ) ), 1,
_selection IN { "01L", "02O", "03V", "04R" }, BLANK (),
2
)
Best Regards,
Community Support Team _ Eason
Hi
Please find below the link to PBIX file and help.
Regards,
egorlinus
The change resolved the specific scenario but caused issues with other rows. So the issue persists. I am surprised that no one is able to help resolving this. Is it a product bug?
Hi, egorlinus
I don't seem to have a similar problem here.
Which version of PowerBI are you currently using? Please download the latest version of PowerBI and test it again.
Best Regards,
Community Support Team _ EasonHi
I am using the Aug-22 version.
Problem was with the values stored in the variables. I rounded off all the variable values and the issue is finally resolved.
Thanks for your response though as no one else responded.
Regards.