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

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    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.