Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I have a table where I have the daily number of actions (column "total") done by each team member (column "name") on each specific task (column "id").
Data Table
I use this data in a matrix that serves to recap most of the data in my report with the possibility to drill from year down to month, week and day.
Most of my data interacts fine and is summed up accordingly, except the one coming from the table above.
The matrix needs to display the number of active tasks - with the definition of active being that there should have been more than 10 actions done in the period selected.
Therefore, the drill down should be that an action is considered active in the month is there was more than 10 actions in total during the month no matter the day, and 10 in total during the week no matter the day and then 10 in total on a given day.
However, the drill down doesn't work right. The number is right when the granularity is daily but if I drill up to weekly or monthly views, the numbers are wrong.
I have tried various different measures:
Hi @Alizee ,
Could you pls share your pbix file ,remember to remove confideential data.
Best Regards
Lucien
Hello @v-luwang-msft ,
Thank you for your reply, here is my test file for this issue.
https://1drv.ms/u/s!ArUIK7v4HwSbg6NulSN4yd-J-aHtWQ
Thank you very much,
Kind Regards,
Alizée