Forum Discussion

mehlenbae2's avatar
mehlenbae2
Helper II
3 years ago

Fix Measure to show Data Point as Table

I have a measure that looks like this:

Priority 1 = Calculate(average('ALL'[Met Target]),Filter('ALL','ALL'[Priority]="Priority 1")) and it gives me the average percent of tickets that met the target, which is exactly what I want. However, when I put my multiple measures with different priorities in a matrix - I cannot export the full data set. I am usually able to  right click "export data point to table" but I cannot with these measures. 
I'm thinking the reason is due to the measure not seeing the unique ticket ID's. I'm not good at DAX and unsure of how to make a measure to do this. Anyone have any ideas?
Need Help

3 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    3 years ago

    Naming a table ALL is not the best idea since there's a DAX function called exactly this name. Please change this before it becomes an issue. As for the problem at hand... It's not possible to diagnose without actually being able to lay a hand upon the data itself.

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    Hi mehlenbae2 ,

     


    In order to better understanding your demands and give the right solution, could you please share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

     

    Thanks for your efforts & time in advance.

     

    Best regards,

    Yadong Fang

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

    • mehlenbae2's avatar
      mehlenbae2
      Helper II
      3 years ago

      Hi there,

      My measure is grabbing tickets from my "ALL" data set with a "3 - Moderate" priority and then averaging the Met SLA column which consists of 0% and 100%. However, I am unable to right-click the average value in my matrix and view data point as table. I would like for this to happen so we can look at all tickets in each priority by viewing data point as table.