Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |