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
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    Please try:

    NFF qty = 
  IF( 
    NOT(ISINSCOPE('pl_master_data naprawy'[uszkodzony])),
    SUM('pl_master_data nff'[qty]))

    Best Regards,

    Jianbo Li

    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
3 years ago

 

22 value is valid only 320 category, for the rest of the them is showing max

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Anonymous ,

 

Sorry, I'm still not quite sure what you mean. What is the difference between Qty and qty? Which table are they calculated through? You mentioned that "22 value is valid only 320 category, for the rest of them is showing max" does that mean 22 is the sum of 320 category types? Should the rest of the values be showing max? Please correct me if I am wrong, and if you can, please provide a simple sample without sensitive data and expected results to help me understand your question better.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

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