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
Hi There,
I have two columns in two differnet Tables
Table 1 : Analysis & Column Name : Missed Revenue
Table 2 : Billing & Column Name : Revenue
I want a Card to hold the percentage of 'Missed Revenue/Revenue'
I tried to create a measure to solve this :
Measure = sum(Analysis[Underbilled Cost]/sum(Billing[Revenue]))
but am getting error as ' SUM function only accepts column reference as an Argument '.
Alternatively, if this is wrong approach can anyone please direct me to how to solve this aother way.
Thanks,
AB
Hi@ AMB_PI
You can use this measure as below:
Measure = sum(Analysis[Underbilled Cost]) / sum(Billing[Revenue])
Result:
Best Regards,
Lin
Do this method acceptable to use column reference as an argument??
You missed the bracket. http://prntscr.com/kmyky5
Try it DIVIDE(Analysis[Underbilled Cost];sum(Billing[Revenue]))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
90 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |