Forum Discussion

Shetta_17's avatar
Shetta_17
Regular Visitor
2 years ago
Solved

how to get total from pivot data

Hi PowerBI Expertise, 

I'm having difficulty calculating the total result from the following raw data.
I want to display the "Total result" achieved and not achieved based on data that has been pivoted from existing raw data"

I hope to get a solution from this forum.

 

Thank You

Need Help

6 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    2 years ago

    Hi, Shetta_17 

     

    Can you tell us what logic John and Christ followed to judge it as this result?

     

    Best Regards

    • Shetta_17's avatar
      Shetta_17
      Regular Visitor
      2 years ago

      Hi v-zhangti the logic is that want to get an average score based on name (which can later be filtered by week, month, etc.). I want to get the total of those who achieved and "not achieve" based on their names based on the average score obtained by the named unit, not based on each ticket/score unit.

    • Shetta_17's avatar
      Shetta_17
      Regular Visitor
      2 years ago
      Hi Ahmedx if I want to show the total achieve by Week, why does the data not show perfectly? any dax to show that? Thank u