Forum Discussion
Solved
Anonymous data
I would like to have a table with the columns name and amount spent, but when I click on a button, the contents of the column name can be anonymous, something like: Paul 1.000 John 1.500 Kate ...
- Value Total =SWITCH (SELECTEDVALUE ( Slicer[Slicer] ),"Hide Name",CALCULATE (SUM ( Data[Value] ),TREATAS ( VALUES ( Slicer[Name or ID] ), Data[ID] )),"Name",CALCULATE (SUM ( Data[Value] ),TREATAS ( VALUES ( Slicer[Name or ID] ), Data[Name] )))
Value Total =
SWITCH (
SELECTEDVALUE ( Slicer[Slicer] ),
"Hide Name",
CALCULATE (
SUM ( Data[Value] ),
TREATAS ( VALUES ( Slicer[Name or ID] ), Data[ID] )
),
"Name",
CALCULATE (
SUM ( Data[Value] ),
TREATAS ( VALUES ( Slicer[Name or ID] ), Data[Name] )
)
)