cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Power BI Calculation mechanism in Power BI Dashboard

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

1 ACCEPTED SOLUTION
Community Support

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

2 REPLIES 2
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors