Sub totals not showing

[IanCockcroft]

Hi   guys, I have a matrix that sometimes shows subtotals and sometimes not.

Any idea why?

[TheoC]

Hi @IanCockcroft 

You can try to modify your Total Swipes by BU something like the below to sum by category:

Total Swipes Per BU = 
VAR _1  = CALCULATE ( SUM ( 'Table'[Accessed in Period] ) , FILTER ( ALLSELECTED ( 'Table' ) , [Business Unit] = MAX ( 'Table'[Business Unit] ) ) )
RETURN
IF ( _1 = 0 , 0 , _1 )

Just modify the above to your table names etc. You may need to adjust the syntax slightly but hopefully gives you what you're after.

Cheers mate.

Theo

[IanCockcroft]

That was my  first thought, but threr are no blwnks under the first row?

[TheoC]

@IanCockcroft did you have any resolution on the issue?

[CNENFRNL]

BLANK() is NOT 0. Enclose your measure in ISBLANK([measure]) to test it.

[TheoC]

@IanCockcroft and @CNENFRNL , when working with values, the output of BLANK() in a visual like KPI has always been resolved for me using IF 0 else 0.  However, the logic behind the ISBLANK (...) makes sense, too.  Run with ISBLANK and hopefully that resolves your issue.

[TheoC · Accepted solution]

Hi guys,

Interestingly enough, I put the below together to show that a null value is represented as a 0 when using values.  Please see below. Text column is text. Value column is a whole number. Column on right is just Calc Column.  

[CNENFRNL]

Simply because the measure evaluates to BLANK() in those cells.