Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a Power bi Dashboard that I have Inherited the ownership and it appears that the Dax calculation is not working right, The values for the age buckets should not be the same accross the board.
OH INVENTORY - EQ QTY_2 =
VAR PRIMARYUOMFILTER = FILTER('DYNAMIC INVENTORY DATA',[PRIMARY UOM]="BIN" || [PRIMARY UOM]="CTN" || [PRIMARY UOM]="PLT")
RETURN CALCULATE(SUM('DYNAMIC INVENTORY DATA'[ON HAND EQUIVALENT QUANTITY]),PRIMARYUOMFILTER)
User | Count |
---|---|
55 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
83 | |
54 | |
39 | |
21 | |
15 |