Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
From the table I need to check if duplicate employee exists. If yes, then find the largest wage.id for the employee and then return the wage. if no duplicates, then return the wage. I have a measure, which works fine otherwise but with duplicate employee Id's the measure returns the sumx of value * 2. For example my table has duplicate id and the newest wage is 3600 but measure sums it wise ending to result 7200.
Solved! Go to Solution.
You are welcome. Modify the measure to
Measure = SUMX(VALUES(Data[Employee.id]),CALCULATE([Wages],FILTER(VALUES(Data[wage.id]),[Highest wage id]=[Highest wage across all wage id's])))
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Ashish_Mathur and thank you for the suggestion! Your measure seems to be working otherwise but the total is not calculated correctly
You are welcome. Modify the measure to
Measure = SUMX(VALUES(Data[Employee.id]),CALCULATE([Wages],FILTER(VALUES(Data[wage.id]),[Highest wage id]=[Highest wage across all wage id's])))
Hope this helps.
Hi, still something funny with the measure. I don't understand from where the total sum comes. Here is the tablle and expected results. So Total sum should be 27 649,30 but the measure total is 46 800.
Share the link from where i can download your PBI file. Show the probelm there clearly and also show the expected result.
Sorry , this was my bad. I made a little mistake modifyin the measure a little bit. Your suggestion did the job as should and expected! Thank you very much!
You are welcome.
Hi,
I create the below dax measure and it seems work :
Appreciate for Kudos
Hi @MahyarTF and thank you for the suggestion. This solution is otherwise working but the total is not calculated correctly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |