Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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]))
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |