Hasonvalue / Comment Column - dont want subtotals

[Anonymous]

Hello,

I have a measure using this formula for a comment column on the very end of my matrix:

Comment Measure =

IF ( HASONEVALUE ( Jahr_Plan[Customer] ), MAX ( Jahr_Plan[Comment] ) )

I did not want the matrix to show me the total (as it was the first comment) but it still shows me the subtotals in this case (which is also the first comment).

Is there any way to also not showing the subtotal for this column?

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure as below.

Score for name = 
IF(
    ISINSCOPE('Table'[Name]),
    SUM('Table'[Score]),
    IF(
        ISINSCOPE('Table'[Class]),
        BLANK(),
        IF(
            ISINSCOPE('Table'[Grade]),
            BLANK(),
            SUM('Table'[Score])
        )
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer for subtotals

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/