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 @PowerK it is NOT Best practice to use DAX function ALLSELECTED in one measure and later use that measure in some other measure. Why, because it is hard to understand results, spot unlogical amounts. The best practice for ALLSELECTED is to use it in visual, not as reference to some measure.
In your example ALLSELECTED is created in 2) and used in 3).
Rewrite your measures.
Proud to be a Super User!
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |