GETPIVOTDATA equivalent in Power BI Desktop

[bibeginner90]

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?

[v-stephen-msft]

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.