Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I have a table of employees with thier sector and a calendar table. On my calendar table i have a column which return 0 for Holidays and weekends and 1 for workings days.
I created a mesaure for return total workingdays
WorkingDays=
SUM( _calendar[working Days] )
However when i place a visual table or matrix and add the employee names + the measure and then select a mesure in the slicer the table is not being filtered with the selected sector, it still showing all employees. Although when i remove the measure it shows all employees related to the selected slicer.
Waht i am trying to achive is:
If i have 2 employees filtered and the month is 22 days working days, on the visual table or matrix will display 22 for each and 44 as total working days.
Any thoughts?
Solved! Go to Solution.
Hi I found a soluction.
I just created a second measure:
WorkingDays2=
Calculate( Values(calendar [Month]), workingdays)
Hi @Anonymous ,
Is there a relationship between your two tables? Can you create a sample .pbix file for us to test? Please don't contain any real data and sensitive information.
Best regards
Icey
Hi I found a soluction.
I just created a second measure:
WorkingDays2=
Calculate( Values(calendar [Month]), workingdays)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |