The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi.
I have the following with different dates:
I would like to sum the cost per day of the employee, but without taking into account the date. I would like that independently of the date selected the sum of the cost show only the cost per day, not the sum of the cost per day.
I would like to see this table:
And this table:
Instead of this that it is the sum of the cost per day of all the days per email.
How can I achieve this?
Thanks!
Solved! Go to Solution.
Hi @EsterBR
If you want to sum up by date and team per day, try it:
Measure =
CALCULATE(
SUM('Table'[Cost]),
FILTER(
ALL('Table'),
'Table'[Date] = MAX('Table'[Date])
&&
'Table'[Team] = MAX('Table'[Team])
)
)
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @EsterBR
If you want to sum up by date and team per day, try it:
Measure =
CALCULATE(
SUM('Table'[Cost]),
FILTER(
ALL('Table'),
'Table'[Date] = MAX('Table'[Date])
&&
'Table'[Team] = MAX('Table'[Team])
)
)
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
not clear about the request.
if you don't want to sum by day, then do not add the date column to the visual
if this does not solve your problem, pls paste the sample data here(not the screenshot) and the expected output based on the sample data you provided.
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
93 | |
88 | |
70 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |