Showing results for 
Search instead for 
Did you mean: 
New Member

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?Picture1.png

Community Support
Community Support

Hi @bibeginner90 ,


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.

Helpful resources

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors