EN VI

Powerbi - How to SUM DISTINCT Values in a column based on a unique count in another column of a Power BI table?

2024-03-12 16:00:08
Powerbi - How to SUM DISTINCT Values in a column based on a unique count in another column of a Power BI table
Employee Claim Amount
James 50
James 20
James 10
Alex 30
Alex 20

I have a table above which I would like to calculate the sum of the claim amount divide by the unique count of employee which is 2 to achieve 65 in PowerBI.

Appreciate if help could be provided with the DAX formula, thank you!

Solution:

Measure = DIVIDE(SUM('Table'[Claim Amount]),  DISTINCTCOUNT('Table'[Employee]))

enter image description here

Tags
powerbi
dax
data-analysis
powerbi-desktop
measure
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09
Author
Avatar
Best Solution
Bot Lv 9
Join Date: 2022-04-13
Keyword
How to SUM DISTINCT Values in a column based on a unique count in another column of a Power BI table, powerbi, dax, data-analysis, powerbi-desktop, measure
Answer

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login