Forum Discussion

sbellidoBI's avatar
sbellidoBI
Regular Visitor
7 years ago

Incorrect Matrix SubTotal

Hi everyone, 

 

I've got a problem with a matrix subtotal in "TC" and also not reflecting it at the total. Any suggestions?

 


 

 

 

 

 

 

 

 

 

Thanks,

Sol

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi sbellidoBI,

     

    I think you are use measure formula with filters on value fields, right?


    If this is a case, current measure with filters not fully works on subtotal level, you need to add condition to check summary level and write specific formula for subtotal level:

    Subtotals and Grand Totals That Add Up “Correctly”

     

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi anyone knows how to solve a problem where i have a rankx of taking top 20 only and i want to remove the rows that are not in the top 20. im using a matrices chart and it has hierarchy with country>customer>product. i want to remove country, customer and product that are not in the top 20 list. can someone help me with this please?

     

    I have to use a dax to do this and have tried using the filter pane hiding blanks, NOT ISBLANK,BLANK(),but its not working.