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.
I finally figured out a DAX to calculate the product of two attributes without creating a table:
That produces the third column below which looks great. The total row is off though as it is following the same logic.
If I add up the third column the true total should be 148,724, not 213,618. I really do not use the total and can hide it. The problem is that I am trying to create a formula for the 4th column that is the correct sum of all items in the 3rd column.
I am using the following formula which is not working:
WeightedCollStaffProcTotal = CALCULATE([WeightedCollStaffProc],All(BRG_PHLEBOTOMY_GROUP[Phlebotomy_Group]))
Suggestions?
Solved! Go to Solution.
Let me give you an example:
In the above picture :
Hi, please try to use this method: Use SUMX+VALUES to wrap your Return.
SUMX(VALUES( the column of current row contents in your matrix ), Return Result)
Appreciate your response. Feel very ignorant here as I am not quite sure what you mean. Do you mean:
Sumx(Values(PhlebAttemptsper,Weightingper))
It keeps wanting a table. Or are you suggesting in the next metric, "WeightedCollStaffProcTotal" to create the sumx? I keep getting the request for a table name???
Let me give you an example:
In the above picture :
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |