Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix invalid relationship

Hello,   I have a little problem with matrix. I m putting values from 2 tables. Second table doesnt have as much categories as the first one and when i m expanding categories there is a problem wit...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

All the left is to put at the end of matrix sum of NFF qty.

 

 

amitchandak any thoughts?

 

NFF qty = 
  IF( 
    ISFILTERED( DimReworkPN[pn]) && NOT(ISFILTERED('pl_master_data naprawy'[uszkodzony])) && NOT(ISFILTERED('pl_master_data translate'[Defects])),
    SUM('pl_master_data nff'[qty]))