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.
First, I just want to say I'm new to Power BI and DAX for that matter. Below I've put a bit of sample data of what I'm trying to accomplish. I'm trying to sum the usage of a certain person on a given date (Total column is what I'm trying to accomplish).
But below is what I'm getting.
The DAX formula that I'm using is: Total = CALCULATE(SUM('Table'[Usage]), DISTINCT('Table'[Date]), DISTINCT('Table'[Person]))
I've been trying to solve this for the last two days and can't figure out why it's not summing the way I want it to... Please help!!
Solved! Go to Solution.
Hi @Anonymous ,
Your DAX expression does indeed not lead to the expected results. The solution of @Tahreem24 is also not working, as you cannot use EARLIER() in a measure. However, you can use it in a Calculated Column.
Try the following DAX in a calculated column:
Total =
VAR currentRowDate = 'Table'[Date]
VAR currentPerson = 'Table'[Person]
RETURN
CALCULATE(SUM('Table'[Usage]), FILTER(Table, 'Table'[Date] = currentRowDate && 'Table'[Person] = currentPerson))
If you want to understand what this does, let me know! I wrote it out so it is the most readable for you 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Proud to be a Super User!
Hi @Anonymous ,
Your DAX expression does indeed not lead to the expected results. The solution of @Tahreem24 is also not working, as you cannot use EARLIER() in a measure. However, you can use it in a Calculated Column.
Try the following DAX in a calculated column:
Total =
VAR currentRowDate = 'Table'[Date]
VAR currentPerson = 'Table'[Person]
RETURN
CALCULATE(SUM('Table'[Usage]), FILTER(Table, 'Table'[Date] = currentRowDate && 'Table'[Person] = currentPerson))
If you want to understand what this does, let me know! I wrote it out so it is the most readable for you 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Kudo's are welcome 🙂
Proud to be a Super User!
@Tahreem24 and @JarroVGIT these both work, thank you so much from keeping me from pulling my hair out!!
@Anonymous I don't want to be a posterboy for bad sportmandship but @Tahreem24 solution cannot possible work as a measure. That would only work as a calculated column.
EDIT: Apologies @Tahreem24; just read your last post 🙂
Proud to be a Super User!
Should there be a closed parenthesis after Earlier(Table[Datecolumn ] )? I keep on getting an error: Too many arguments were passed to the FILTER function. The maximum argument count for the function is 2.
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 |
---|---|
112 | |
103 | |
75 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |