CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
Serdia
Serdia

Reputation: 4428

How to add calculated column to existing table that would ignore selected value in a slicer Power BI

I need to add calculated column that would ignore values selected in a slicer:

I tried:

all users = ALL(Sheet1[UserName])

But it gives me an error: A table of multiple values was supplied where a single value was expected.

enter image description here

Upvotes: 0

Views: 163

Answers (2)

PowerStar
PowerStar

Reputation: 895

If I understand you correctly, You have to use ALL() Function by creating new table Under the modelling tab

enter image description here

Upvotes: 0

Alexis Olson
Alexis Olson

Reputation: 40204

A calculated column cannot be affected by a slicer but that's not what you seem to be referring to.

It appears you are trying to create a visual that lists all the users. For this, you can put Username on a table visual and disable the filtering from the slicer by going to the Format tab and clicking Edit interactions.

Upvotes: 1

Related Questions