Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Total Row Count in Matrix Visual with Visual level filter

Dear Community, I have a scenario where i have department with multiple codes. Each department has 3 sub departments with each sub departments having codes on different months. I am using matrix vis...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous hey add following two measures and then use Code Count in your matrix

     

    Total Count = COUNT( Child[Code] )

Code Count = 
IF (
    ISINSCOPE( Child[Depart]), 
    [Total Count], 
    CALCULATE( 
        [Total Count],
        ALL(Child[Depart])
    )
) * DIVIDE( [Total Count],[Total Count])
tex628's avatar
tex628
Community Champion
7 years ago

The example i gave will not give you the result that you are looking for, sorry! Take a look at my previous reply and see if that can be applied. 

In regards to the image below, I forgot to add a ")" after the all('Parent') statement, thats why it's not working!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi tex628 ,

 

I tried including the close bracket ")" and im getting the row level fitlered count only. As my source is Live connection, im not able to alter the data. Thanks for your suggestion and help. Will try out an solution for this. 

 

Thanks alot.