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

Can you do a

IF(
Selectedvalue('Departments'[Department]) = BLANK()
, 
Calculate([Total count] , all('Departments')
,
[Total count])

Department being the column dimension that your using. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi tex628 ,

Thanks for your reply. PBI is not allowing  to use a calcualte column inside a IF condition. Please find the image for reference. Glad you could try for an solution. Kindly do let me know if there are any workaround for the same. 

 

Thanks  &Regards,Praveen 

 

  • 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.