Forum Discussion
Replicate Excel Pivot in Power BI
Hello All! I have this Excel pivot with filters and would like to replicate this in Power BI. Note that this changes based on selected filters, where Total ID = TPID Count, Actual = M...
amitchandak
Super User
Super UserAnonymous , You can create a matrix Visual
Subsidiary on Row, Qtr on the column
And following values
Measures
Actual = Sum(Table[MEI Rank Actual]) // use count if needed, place of sum
Total ID = Count(Table[TPID])
% = divide([Actual], [Total ID])