Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |