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.
Hello!
I created a measure on calculating Sum quantity under several column filters under the same table.
But when I drag the item code, location code, bin code and quantity to the visual table under Power BI, the bin code is still showing the data I don't need. And the quantity didn't seem any different to what I have from the original quantity Sum. Anyone can have a look at what's going on?
Replicating Tableau Parameter/Filter in Power BI
Thank you!
Shine
My misitake, it does look like you need the OR (||) operator.
Maybe the issue is too many comparisons in one Measure.
Try to break it up into multiple measures and test one condition at a time until you see the issue come up
|| is the OR operator, maybe try the AND operator - &&
Hi Thomas,
After I changed all the || to &&, I cannot see any valid data in the matrix table.
Did I make anything wrong?
Shine
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |