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])
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dear members, 

This accepted solution works best for the scenario i have mentioned in the screenshot(which is import mode).

I solved my acutal issue where my source is Live Connection ( SSAS Cube) and the "ISINSCope" function is not supported yet. 

 

To get the current context i used "MAXA" instead of "ISINSCOPE" to calculate the count. Posting this solution for live connection for any members reference. Thanks all. parry2k , Cmcmahan tex628 

  IF(  
       MAXA(Parent[Depart]), Total Count]
       ,CALCULATE( [Total Count], ALL(Child[Depart])
     )