Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Slicer Using Measure Based on Criteria

Hi,   Is it possible for a slicer to accommodate a measure based on criteria e.g. the screenshot showed criteria for Negative Variance, Negative Variance with No Sales, etc?   //NT      ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

My Comment is different from the one you'd shown. I created a new table and when I followed your dax all returned to zero as shown.

 

Comment_drd =
    SWITCH (
        TRUE (),
        'gbkmut_pns_drd'[Variance] = 0.001, "No Revenue",
        'gbkmut_pns_drd'[Variance] < 0 && gbkmut_pns_drd[abs] = 0, "Negative Variance with No Revenue",
        'gbkmut_pns_drd'[Variance] < 0, "Negative Variance",
        'gbkmut_pns_crd'[abs01] = BLANK() && gbkmut_pns_drd[abs] > 0, "No Cost But With Revenue"
        )
 

 

 

hnguy71's avatar
hnguy71
Super User
2 years ago

Hi Anonymous 

Seems you're still missing the slicer on the page. Can you also share what's inside your "Filter Flag" meaesure?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

     

    I created the filter as shown.

     

    I'm also sharing you the dax i created for the filter flag

     

    Filter Flag =
    VAR CurrentClassification = gbkmut_pns_drd[Comment_drd]
    VAR CurrentSelection = SELECTEDVALUE('Filter Comment'[Selection])
    RETURN
    SWITCH(
        TRUE(),
        CurrentSelection = "Negative Variance" && CurrentClassification = "Negative Variance",1,
        CurrentSelection = "Negative Variance with No Revenue" && CurrentClassification = "Negative Variance with No Revenue",1,
        CurrentSelection = "No Cost But With Revenue" && CurrentClassification = "No Cost But With Revenue",1,
        CurrentSelection = "No Revenue" && CurrentClassification = "No Revenue",1,
        CurrentSelection = "No Cost, No Revenue" && CurrentClassification = "No Cost,No Revenue",1,
        0
    )

     

     

    • hnguy71's avatar
      hnguy71
      Super User
      2 years ago

      Hi Anonymous ,

      One thing to keep in mind is that your string inside your comment measure must match the string inside your flag measure:

      Filter Flag =
VAR CurrentClassification = [Comment_drd]
VAR CurrentSelection = SELECTEDVALUE('Filter Comment'[Selection])
RETURN
IF(CurrentSelection = CurrentClassification, 1, 0)

       
      Also, make sure that there's a selection from your dropdown for it to turn from 0 to 1.

      I've linked a sample for you so you can get a feel of what to do:
      tksnota_filter_measure.pbix