Forum Discussion

BI_Flo's avatar
BI_Flo
Regular Visitor
5 years ago

ISINSCOPE Measure in Matrix Visual with Hierachy Filter

Hi everyone,   I have a matrix visual representing a BOM (Bill of Materials) which was created with the PATH() function. Depending on the hierarchy level which ISINSCOPE=True in this matrix I want ...
Need Help
Tips and Tricks
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

BI_Flo 

Thanks for the message and file. Can you provide a depiction of the expected output? it's hard to follow by reading extensive measures!

  • BI_Flo's avatar
    BI_Flo
    Regular Visitor
    5 years ago

    Hi Paul,

     

    this is how it should look like. If I apply the filter for "DRW100" the red total amount for DRW221 should change from 2 to 1. The Measure should look for the "Art.Nr" which is in a single distinctive column. 

     

    Thanks and kind regards,

    Flo