The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Sample:
Phase | INPUT | OUTPUT | RESULT |
PP | 10 | 5 | Division of Cleared with Input |
PRO | 20 | 10 | Division of Cleared with Input |
OT | 30 | 15 | Division of Cleared with Input |
Overall | PP*PRO*OT |
I have added the Measure to calculate Cleared with Input which is the division of Cleared being Numerator with Input being Denominator.
How do i multiply the Results of all three phases and get the FINAL RESULT in the Overall Row as mentioned above?