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,
I tried to get the average of Minute of works from certain period per employee which measured the sum of MOW divide by (number working days - number public holiday and employee leave. Now i want my matrix show the average directly from the column without calculated average from the tabel again.
here is my matrix
I want the average total is shown the average of value from cell matrix. which is for example in 2023 jan i get the value = 526.1
i try the measurement below but it failed
Solved! Go to Solution.
Hi @lbendlin
really appreciate your help with this issue, already got what i needed by combining your approach and my previous approach, the measure is like this :
HI @lbendlin really appreciate with your answer.
ur answer so close with i wanted to find, but it cant handle the scenario :
1. FactWorkDetails[Date Our] can be on holiday date and / or Weekend date
2. Date in holiday table is belong to PIC Full name
but i follow your approach by creating new table and adjust the Dax formula to suit my need and it works wonders, but when i try to convert it into measure the grand total wont show average. can you help whats wrong with my measure (measure 4)
https://drive.google.com/file/d/1rRSBiPEYN6kQI4kYkvQV3Tz34YssqQzl/view?usp=sharing
Hi @lbendlin
really appreciate your help with this issue, already got what i needed by combining your approach and my previous approach, the measure is like this :
User | Count |
---|---|
49 | |
48 | |
19 | |
16 | |
15 |
User | Count |
---|---|
110 | |
45 | |
42 | |
24 | |
20 |