The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Is it possible to divide Total values and add it to a new measure?
For example in this screenshot, I would like to divide the 80/100, where both are measure values already.
Thank you,
Hayman
Solved! Go to Solution.
"Is it possible to divide Total values and add it to a new measure?"
Don't know what this means. Do you mean create a new measure in this same table that just shows the quotient at the "Total" row? Or display in a completely different table/visual? Because all you should have to do is:
Divide Measure = DIVIDE( [TI_Cumulative] , [IMPE_Cumulative] )
"Is it possible to divide Total values and add it to a new measure?"
Don't know what this means. Do you mean create a new measure in this same table that just shows the quotient at the "Total" row? Or display in a completely different table/visual? Because all you should have to do is:
Divide Measure = DIVIDE( [TI_Cumulative] , [IMPE_Cumulative] )
Please advise.
Regards,
Hayman