HASONEVALUE problem

[bjurek]

in the Power BI Dekstop program, I have 4 columns that I place in the matrix visualization.
I put Year column, Month column and Day column in rows and Value column in values.
Would like to not show the sum of the values ​​for the IValue column when the columns are collapsed. Unfortunately, after collapsing the columns, the sums for the columns appear and I don't want that. I have used the HASONEVALUEe function as below but the sum still appears.

IF(HASONEVALUE(Table_Name[Year]), Table_Name[Value], BLANK())

[mlsx4]

Hi @bjurek 

You can use ISINSCOPE

sumSc = SWITCH(
    TRUE(),
    ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
    BLANK()
)

[bjurek]

it is not working 😞

[mlsx4]

But where are your rows?

[bjurek]

Sometimes i need colaps Month=1 and i dont want show sum of value for Month=1. Can you do it ? 

[mlsx4]

If you write a "", it will keep the value visible:

[bjurek]

Columns which i grouping are: Year, Month, Day. 
Value column is: Value
Table with Year,Month,Day nad Value is Table_Name. 

Maybe I make some wrong with name of columns or table. I dont know 😞 

[mlsx4]

But if you do this, doesn't it work?

sumSc = SWITCH(
    TRUE(),
    ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
    ""
)

[Momo2020]

Dear mlsx4,

thank you for your suggestion of ISINSCOPE function. I was struggling with HASONEVALUE in case where there was only one value in one group, while I wanted to show the value only on total rows. You saved my mind!

Best regards,

Monika

[bjurek]

no value 😞 

[mlsx4]

It is a measure, not a calculated column

[bjurek]

[mlsx4 · Accepted solution]

I have exactly the same but Year, Month and Day are text type: