Forum Discussion
Helper IFilter report as per slicer selection
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 ?
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.
3 Replies
- djurecic
Super User
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.
- 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.
bhuprakashsI have created below measure to identify Allocation or Deallocation.
Chk =var selectionCheck = SELECTEDVALUE(Slicer[AllocationChk])RETURNSWITCH(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.
