Forum Discussion
Total Row Count in Matrix Visual with Visual level filter
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 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])Hi parry2k ,
Thank you for the solution.
It works perfectly in ths sample code i have provided. But my actual scneraio has a cube source and ISINScope is not available for Live connection sources. Is it possible to get a solution for a live connection sources please.
Kindly let me know about this.
Thanks & Regards,
Praveen
Can you do a
IF( Selectedvalue('Departments'[Department]) = BLANK() , Calculate([Total count] , all('Departments') , [Total count])Department being the column dimension that your using.
tex628
The problem with that solution is that you still have a SELECTEDVALUE if there's only one record in the subgroup. So it would work in most cases, but still give you the wrong result when there's only one value.
Honestly, these workarounds for matrices are ridiculous, and I encourage everybody to vote on this idea to allow custom totals/subtotals: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in
Oh man, ISINSCOPE is amazing. It would have solved so many problems I've had with matrices. Thank you for pointing it out!
