Forum Discussion

bhuprakashs's avatar
bhuprakashs
Icon for Helper I rankHelper I
1 year ago
Solved

Filter 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,...
Need Help
  • djurecic's avatar
    djurecic
    1 year ago

    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's avatar
audreygerred
Icon for Super User rankSuper User
1 year ago

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's avatar
    bhuprakashs
    Icon for Helper I rankHelper I
    1 year ago

    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.