Forum Discussion

GP1234's avatar
GP1234
Frequent Visitor
5 years ago
Solved

Swtich DAX Error

Problem solved. I had wrong DAX.
Need Help
Tutorial Requests
  • selimovd's avatar
    selimovd
    5 years ago

    Hey GP1234 ,

     

    I'm not sure if I understood your question.

    Your table doesn't contain a row "Total Revenues", so the measure will return BLANK():

     

    That's what you put in the measure and the result is as expected.

    Now what exactly did you expect as a result?

     

    Best regards

    Denis

GP1234's avatar
GP1234
Frequent Visitor
5 years ago

Because data = 0, Total Revenues is not shown in the 1st table. If you look at 2nd table, "Total Revenues" is there. I made 2nd table to show blank.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey GP1234 ,

 

if my post helped you to solve that, I would be happy if you could mark it as solution.

 

Best regards

Denis