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...
I was able to replicate the results of the source data from the cube, and it shows the following breakdown.
This is the expected output,but something is wrong when I put another level of drilldown to it, where
INCORRECT as this one sould have still 591 in the Enterprise segment group instead of 5319. Same goes with other segment group.
It looks good in the cube's excel pivot, though.
Thanks for your ideas amitchandak . Appreciate it!