Filter report as per slicer selection

[bhuprakashs]

Hi Experts,
Greetings!

I need your help to write a DAX/Solution basis of below condition. 
I have a data table which has Account_Number column. Lets suppose Account_Number column has values 1,2,3,4,......10. Now I have to give a slicer (Allocated | Deallocated) on the report - If I select Allocated from slicer then show all 10 records. If I select  Deallocated from slicer then show only records 1,2,3,4,5,6 only. I want to exclude 7,8,9,10. How can I achieve this ? 

[audreygerred]

You can add a column that designates which records are Deallocated. If not deallocated, have them be allocated. Then in the report, if someone selects nothing they see all the records. If they select deallocated they only see those records. If they select allocated they will only see those.

[bhuprakashs]

I have created below measure to identify Allocation or Deallocation.

Chk =

var selectionCheck = SELECTEDVALUE(Slicer[AllocationChk])

RETURN

SWITCH(

    TRUE(),

    selectionCheck = "Deallocation" && VALUES(Sheet1[Account_Number ]) in {1,2,3,4,5,6} , 1 , 0 )

   

now I am using this measure in filter pane and filtering only 1. This is giving me 0 result if I am selecting Allocation from slicer. and correct result if selecting Deallocation.

[djurecicK2 · Accepted solution]

Hi @bhuprakashs ,

 You could create an allocationstatus column and set it to the appropriate value depending on Account_Number. Then use that allocationstatus field in the slicer.