powerbidaxdata-analysispowerbi-desktopmeasure
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]))
- Unable to connect python script in PowerBI
- Power Bi - Change font color of text in Matrix Visual
- Eliminate customer with less than 2 products from the List
- How to filter a table based on a particular date in power BI
- MoM comparison on Area Chart results in +1 day
- DAX filter a Measure by an other Measure
- count distinct of 2 modalities at scale
- How to Set Default Collapsed State in Deneb-Vega Gantt Chart for Power BI
- Power BI calculate Measure for previous working day
- Calculate first date similar to sql window function in DAX
- User doesn't have permission to call the Discover method
- Changing the Color of a Set of Bars of a Clustered Column Chart
- Combining Measures from different Tables
- Distinct Count Rows with filter on Same column with Multiple Rows
- Configuring PowerBI on-premise gateway for SQL Server
- Creating a Music Podium top 5 - like visualization in Power BI from a table
- Using DAX to create a dynamic horizontal line for a bar or line chart in Power BI
- TypeError: Cannot read properties of undefined (reading 'tokenType')
- Sort Text Numbers in ascending in Slicer
- How to lookup Grades corresponding to Marks scored by students from a Grade-Slab table in Power BI?
- Is there any way to invoke PowerQuery/M outside of Excel or PowerBI?
- Identify grouped rows based on multiple conditions using PowerQuery
- How to show timeseries data up to selected month in Power BI line chart with a Slicer
- custom column based on the length
- Power BI Dashboard Does not refresh in Big TV
- Power BI :: No conditional formatting on the bar color
- Power bi drop down menu
- On selection of a product from a product vs sales bar chart, I want to see top 3 user comments about that particular product
- Using DAX in PowerBi to change data format from wide to long
- How to use DAX to filter rows based on a date slicer