Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

GETPIVOTDATA equivalent in Power BI Desktop

Dear all,

I was able to create a doughnut chart with this dynamic 2-cell table that uses GETPIVOTDATA to get the total from a pivot table and the second cell is (1-the other cell). I can slice this table and still get correct dynamic results.

How do I reproduce this dynamic table in PowerBI?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    There's a similar post you could refer to

    Solved: Getpivotdata equivalent - Microsoft Power BI Community

    Usually use the SUMMARIZE function to get a table in the measure, and then use the SUMX function to sum the fields based on the table created.

     

    Best Regards,

    Stephen Tao

     

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