Forum Discussion
SUMX() Help
Hello: A sample of my data set is below. The beige shading is data from Power BI. The blue shading is done in Excel. I am not able to build the logic of the blue cells in Power BI. 'Earned Ho...
saraMissBI
Resolver I
Resolver IHi edwardwe ,
Please try the following measure:
Measure = SUMX('Table';DIVIDE('Table'[OrigEstHours];'Table'[OrigEstUnits];0)* SUM('Table'[Actual Units]))
If that works for you, please accept as solution and give kudos!
Best regards,