Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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())
Solved! Go to Solution.
Hi @bjurek
You can use ISINSCOPE
sumSc = SWITCH(
TRUE(),
ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
BLANK()
)
it is not working 😞
But where are your rows?
Sometimes i need colaps Month=1 and i dont want show sum of value for Month=1. Can you do it ?
If you write a "", it will keep the value visible:
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 😞
But if you do this, doesn't it work?
sumSc = SWITCH(
TRUE(),
ISINSCOPE('Table'[Day]),SUM('Table'[IndeksVisible]),
""
)
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
no value 😞
It is a measure, not a calculated column
I have exactly the same but Year, Month and Day are text type:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |