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.
Hello everybody,
I'd like to ask you for help with a calculated column.
I'll use the following table to demostrate it on an example
In order to get the Requested column I use this formula:
Requested =
CALCULATE (
SUM (Query1[hours] );
FILTER (
ALLEXCEPT ( Query1; Query1[User] );
Query1[project_category] <> "_Attendance"
)
)
It works, however, when I use the slicer for the visualization, the date slicer doesn't have any influence in my new column and it still returns only one (the total) value.
Is there anything I can do about that? Any formula taht cooperates with the date and will return a value only for the time period I filter using the slicer?
Thanks in advance
Solved! Go to Solution.
Hi @Murkow,
Please try below measure:
requested = CALCULATE ( SUM ( Query1[Hours] ), ALLSELECTED ( Query1[Spent_on] ), ALLSELECTED ( Query1[Project category] ), Query1[project category] <> "_Attendance" )
Best regards,
Yuliana Gu
Hi @Murkow,
Please try below measure:
requested = CALCULATE ( SUM ( Query1[Hours] ), ALLSELECTED ( Query1[Spent_on] ), ALLSELECTED ( Query1[Project category] ), Query1[project category] <> "_Attendance" )
Best regards,
Yuliana Gu
Hi Yuliana,
great help, thank you!
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |