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.

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

Hi Anonymous ,

 

Based on your description, I have create a simple example:

Apply the measure:

Measure = IF(ISINSCOPE('Table'[Subcategory]),BLANK(),CALCULATE(SUM('Table (2)'[Qty]),FILTER(ALL('Table (2)'),[Category]=MAX('Table'[Category]))))

Output:

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

It looks promising but the behaviour doesnt apply to Category B,C.

 

Each Category need to be preserved without subcategories values in 2nd column

 

Category A 22

Category B XX

Cat C XX