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

Do I need to create a separate table in the power query as the initial step?

hnguy71's avatar
hnguy71
Super User
2 years ago

Hi Anonymous , 
A separate disconnected table, yes, but it doesn't need to be creaetd in power query if you don't feel like it. You can select "New Table" and use the DATATABLE function to create your table:

 




  • 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
        )