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 want to look at all the assignment we have in a table.
In this table I want to see price for all the closed assignments the month it was closed.
The table also have multiple assignments that have not been closed yet and they need to be in the table so I cannot just remove them with a filter.
So I have made this filter to see which assignments has been closed in a give month it returns 1 if it has been closed and 0 if it hasn't been closed this month.
But the sum also 1 which means that it includeds the price for all values. See screenshot.
Is there something I can do to only add the value in the sum for the rows where the 1 is shown and not all of them?
Solved! Go to Solution.
Try this measure
test= IF(HASONEVALUE('calendar'[label]),[test 4],sumx('Assignment',[test 4]))
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Try this measure
test= IF(HASONEVALUE('calendar'[label]),[test 4],sumx('Assignment',[test 4]))
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |