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 1.800
to
Name 1 1.000
Name 2 1.500
Name 3 1.800
Someone help me?
- 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] )))
1 Reply
- 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] )))