Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Matrix View issue

I haved the pbix. I need below view with an additional feature. When I try to create below view in Matrix and put the Shipment # column in values, it gives first Shipment and displays just one valu...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  learner03 ,

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _shipped=CALCULATE(SUM('Sheet6'[Shipped QTY]),FILTER(ALL(Sheet6),'Sheet6'[Dock#]=MAX('Sheet6'[Dock#])&&'Sheet6'[Container #]=MAX('Sheet6'[Container #])))
var _received=CALCULATE(SUM('Sheet6'[Received Qty]),FILTER(ALL(Sheet6),'Sheet6'[Dock#]=MAX('Sheet6'[Dock#])&&'Sheet6'[Container #]=MAX('Sheet6'[Container #])))
return
_shipped+_received

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  learner03 ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _shipped=CALCULATE(SUM('Sheet6'[Shipped QTY]),FILTER(ALL(Sheet6),'Sheet6'[Dock#]=MAX('Sheet6'[Dock#])&&'Sheet6'[Container #]=MAX('Sheet6'[Container #])))
var _received=CALCULATE(SUM('Sheet6'[Received Qty]),FILTER(ALL(Sheet6),'Sheet6'[Dock#]=MAX('Sheet6'[Dock#])&&'Sheet6'[Container #]=MAX('Sheet6'[Container #])))
return
_shipped+_received

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly