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.
I am using this DAX measure to show how many tickets were open on each day:
Solved! Go to Solution.
Yes this is because of the ALL statement. You can change it to ALLSELECTED() or ALLEXCEPT() functions.
Hi @richardc1 ,
ALL is a table modifier function. It is basically applying the result of your measure to the whole of 'All Tickets' table so any filter coming from the same table will return the same result. It would be better if you provided a workable sample data (not an image) and from that your expected result. Make sure that the both the sample data and expected result cover your use case/scenario and not just bits and pieces of them.
Proud to be a Super User!
Hi @richardc1 ,
ALL is a table modifier function. It is basically applying the result of your measure to the whole of 'All Tickets' table so any filter coming from the same table will return the same result. It would be better if you provided a workable sample data (not an image) and from that your expected result. Make sure that the both the sample data and expected result cover your use case/scenario and not just bits and pieces of them.
Proud to be a Super User!
Yes this is because of the ALL statement. You can change it to ALLSELECTED() or ALLEXCEPT() functions.
Awesome, thanks for that!
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
91 | |
91 | |
76 | |
70 |