Forum Discussion

awitt's avatar
awitt
Icon for Helper III rankHelper III
6 years ago
Solved

Getting Totals From a Measure

This seems like it should be simple but I'm having issues with working with this measure.   I have two tables with a shared product key. One is an orders table with each row being an individual pro...
Need Help
  • YJ's avatar
    YJ
    6 years ago

    Hi awitt thanks for the detail desc

    For you:

    Because of the If condition, your measures didnt work. It takes a while to get used to and measures are almost always more efficient but in the meantime if you want to be sure you can start with cal columns.
    Anywei i provided the solution both as a measure(M) and cal column (cal)

    PBIX 

     

    regards

     

YJ's avatar
YJ
Icon for Resolver II rankResolver II
6 years ago

Can you provide the pbix file with the source tables

regards

    • YJ's avatar
      YJ
      Icon for Resolver II rankResolver II
      6 years ago

      Hi awitt thanks for the detail desc

      For you:

      Because of the If condition, your measures didnt work. It takes a while to get used to and measures are almost always more efficient but in the meantime if you want to be sure you can start with cal columns.
      Anywei i provided the solution both as a measure(M) and cal column (cal)

      PBIX 

       

      regards