Power BI Calculation mechanism in Power BI Dashboard

[Tanmay20]

We wanted to get the table in power BI Dashboard by calculating formulas like minus, percentage, ratio etc. 

Table format 

Total Debtors 100 

Overdue 20

Not overdue 80 (100-20)

Sales 20

Debtor Turnover ratio 20 (20/100*100) 

So it is required all formulas come in power bi dashboard as the same is not in the backend data.

Please resolve at the earliest

[Ashish_Mathur]

Hi,

Write these measures

TD = sum(Debtors[Value])

OD = sum(overdue[Value])

S = sum(Sales[Value])

Debtor turnover = divide([S],[TD])*[OD]

Hope this helps.

[Anonymous · Accepted solution]

Hi @Tanmay20 ,
Based on your description, there are two 20s in your data and it is impossible to determine which one was used for the final result. You can use selectedvalue to select the data in the table. Here is a simple example

Create mesures

Not overdue = SELECTEDVALUE('Table'[Total Debtors]) - SELECTEDVALUE('Table'[Overdue])

Debtor Turnover ratio = SELECTEDVALUE('Table'[Overdue])/SELECTEDVALUE('Table'[Total Debtors])*SELECTEDVALUE('Table'[Total Debtors])

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly