March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have date from 13 columns that user can change but they need the messure to caluclate the % from total an when they expand the expand be % of the parent not from the grand total tried the below and didnt work any ideas ,
% of Parent Total =
DIVIDE(
SUM(Table[MeasureColumn]),
CALCULATE(
SUM(Table[MeasureColumn]),
ALLSELECTED(Table)
)
)
This was impossible before Visual Calculations were introduced. Now it is trivial. read about COLLAPSE.
i want the expanded to be percentage from what is expanded from what the collapes do with that