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.
You can use this measure as below:
Measure = sum(Analysis[Underbilled Cost]) / sum(Billing[Revenue])
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]))
I also have the same query about this and the question that why sum fuction only accepts column reference as an argument. Need help for this asap.
KissAnime groupme letgo
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.