Forum Discussion

darko861's avatar
darko861
Resolver II
3 years ago

Matrix two level calculation

Hi all,   I have a matrix, with two rows displaying the Member's names (which is blurred out) and their Internal or Customer time. The data model consists of the Members' table (The Members' names ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi darko861 ,

 

Your calculation is based on your data model, please share a sample file and show me a screenshot with the result you want. This will make us easier to find the solution.

 

Best Regards,
Rico Zhou

 

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

  • darko861's avatar
    darko861
    Resolver II
    3 years ago

    Hi Anonymous 

     

    Here is the sample file.

     

    https://www.dropbox.com/s/jfyd9qzqa5qb9hc/Test%20-%20Copy.pbix?dl=0

     

    I would like to have blank values for e.g. Customer 276 and Customer 157 where the row is Internal Time and the column is Targeted Hours5.

     

    At the moment Customer 276 has 142 hours (Jan) and 159 hours (Feb) in the row Internal Time.

    Customer 157 has 0 hours (Jan & Feb) in the row Internal Time. But this is redundant as the Targeted Hours should only be visible in the Customer Time row and not in the Internal Time row.

     

    It should look like customer 200, where the targeted hours only appear at the Customer Time level.

     

    I appreciate the help 🙂