Swtich DAX Error

[GP1234]

Problem solved. I had wrong DAX.

[v-xiaotang]

Hi @GP1234 

Have you solved your problem? If yes, kindly accept the answer helpful as the solution(OR kindly share your solution😁). so the others can find it more quickly.

Or

if problem still persists, please let me know.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[selimovd · Accepted solution]

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]

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]

Hey @GP1234 ,

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

Best regards

Denis