Forum Discussion

egorlinus's avatar
egorlinus
Frequent Visitor
4 years ago
Solved

Calculated measure for conditional formatting returns inconsistent values.

Hi Experts,   I have a typlical scenario wherein the caluclated measure created for conditional formatting is behaving inconsistently. Measure is defined as: Color subtotal = var _laying      ...
DAX Switch()
  • egorlinus's avatar
    egorlinus
    4 years ago

    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.

egorlinus's avatar
egorlinus
Frequent Visitor
4 years ago

Hi

Please find below the link to PBIX file and help.

 

 

Regards,

egorlinus

egorlinus's avatar
egorlinus
Frequent Visitor
4 years ago

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?

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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 _ Eason

     

     

    • egorlinus's avatar
      egorlinus
      Frequent Visitor
      4 years ago

      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.