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.
Hi Team,
I am facing a minor problem. I have a requirement of getting counts of users who are having less than 6 hours. I have writtem code for the same. And it is perfectly working in the Sample DataSet giving correct result, but when replicated the same in my Actual Dataset it is behaving incorrectly. Please note everything is same in both data set weather it is specific filter and data selection. I am not sure how can i debug this. Need your help to resolve this. I tried to bring one more page and tried the same formula, it is working.
In the above left side Sample set is giving correct result for Low Avg Work Time HC(<6hrs) = 13 but in the above right side image, it is showing as 4. In both pages applied filter are same in both cases. Please help to resolve it in my Actual Data set.
Regards,
Sagar
Hi @sagarsahoo_123,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Thanks for your quick reply.
Please find the below link in which you can download the Sample file.
https://1drv.ms/u/s!AqNLfMSghxwyhgVaPes9qbktkg34?e=hNaGMH
Please note that in the "Details" page you will find the low Work time HC brought into Card in the right top above and the matrix table in below and Date column in the slicer of the extreme left of that page.
Please note when the month is selected to all, it is showing the counts correctly who are highlighted in Amber color in the total of matrix table, but when there is a change in month or any month is selected it is not showing correctly. Same issue i am facing in the actual Dataset as well. Please help to resolve. Apprciate your support.
In the above image if you see, month is selected to All and Highlighted total is showing 15 which is correct in the card as well, but in another image month is selected to nov and it is showing 7 in cards but in actual the number is more than that.
Regards,
Sagar
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
76 | |
60 | |
53 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |