Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I searched as much I could, and I could not find anyone with this same issue, so, if it has already been posted, I appologize.
When I use ALL() in a measure, it causes the related data to repeat.
In the data, I have ID_DIVISION in a fact table, that is related to DC ID in a dimension table. The relationships are setup as many to one, with a single direction filter.
When I create the below measure, everything lines up (left table in screenshot below)
Measure = CALCULATE(sum('F_Warehouse Trace LPH Lines'[Lines]))
CALCULATE(sum('F_Warehouse Trace LPH Lines'[Lines]),all('F_Warehouse Trace LPH Lines'))
@mmyers2 ,
To be general, you may modify your measure using DAX like pattern below:
Measure = CALCULATE ( SUM ( 'F_Warehouse Trace LPH Lines'[Lines] ), ALLSELECTED ( 'D_Organization' ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, but that did not work. This is really driving me nuts since I want to use DC ID as a drill through, and also have other metrics on the same report page that crossfilter on DC ID.
The way this is interacting seems very odd to me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |