Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm not sure if this is a known bug or issue, but I have seen some examples of it in the past on the forums but without much being resolved.
In short, I have a table for returns. I create a column (in power query or dax) called Owned, which returns a 1 if a separate column contains a string "31", or 0 if it doesnt. Really simple.
The issue comes when I create a measure sumqty. It sums the qty field in the same table, but wants to do that irrespective of the filter selection on Owned, so I use ALL('table'[Owned]). However, when I apply a filter to said column, I receive a number that makes no sense. This also only breaks if I have a separate filter going onto the same table, but that really shouldn't make a difference based on the measures.
Anyone experience this before? This seems 100% like a bug but I reached out to Microsoft support and they said they couldn't help as I didn't receive an error.
This is the ONLY table I have in the model.
Attached are some pictures.
Hi, @Anonymous
It is really weird, everything is fine on my side.
Maybe you can try formula as below:
SumQty =
CALCULATE (
SUM ( 'Master Returns Table'[quality] ),
REMOVEFILTERS ( 'Master Returns Table'[Owned] )
)
Best Regards,
Community Support Team _ Eason
Yeah, I've tried removefilters() and that doesnt work either.
You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi, @Anonymous
I suspect the problem may be that the date field in your slicer and the owned field in your slicer are in the same table ( you need to keep/remove both filters in formula).
As a workaround, you can add a calendar table(build one-to-many relationship) for the date slicer creation:
scheduled_at Table = CALENDAR(Min('Master Returns Table'[scheduled_at]),MAX('Master Returns Table'[scheduled_at]))
Another solution is to disable the interaction of your Owned slicer with the table visual.
Best Regards,
Community Support Team _ Eason
Hi @Anonymous
Can you share the pbix?
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
How should I share it? I cant attach it in this comment.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |