Forum Discussion

archana_c's avatar
archana_c
Icon for Helper I rankHelper I
2 years ago

Use Filter in DAX and Add a field parameter

I have a table containing loans, loan types and different value fields. I have created a graph visual which shows loans in the x-axis and field parameter (consists of value fields) in the y-axis. I need to add one more slicer for filtering the visual based on the loan type. So instead of adding direct slicer using the loan type field, is it possible to add two measures using filter function and creating a field parameter?
dax v-yuta-msft 

Need Help
Tips and Tricks

3 Replies

  • mohgh's avatar
    mohgh
    Regular Visitor
    2 years ago

    Hope this could helps you out:
    SelectedLoanTypeMeasure =
    SWITCH (
    SELECTEDVALUE('YourSlicerTable'[SelectedLoanType]),
    "Type1", [LoanType1Measure],
    "Type2", [LoanType2Measure],
    BLANK()
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi archana_c ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • archana_c's avatar
      archana_c
      Icon for Helper I rankHelper I
      2 years ago

      hi Anonymous

      Suppose this is the data containing 6 columns. One participant can have more than one loan. I have created a stacked chart with participant in x-axis and field parameter as Y-axis. Field parameter column amount columns. And loans are added as series in the bar chart. So the new requirement is to add one more slicer loan type. The values in the dropdown are Exclude abl, Include abl. When exclude abl is selected we should not consider loans with loa type=abl, where as include abl means we need to consider all the loans. Normal slicer wont work in this case. So there will require some DAX for including and excluding the values. 
      Any help is accepted.
      Thanks in advance