Forum Discussion

andrewjones11's avatar
andrewjones11
Regular Visitor
4 years ago
Solved

Help - conditions on a column

Hi,   Is is possible to apply the following logic to a new column?   If task set = "Quick Quote" and contains a value for "Opportunity Ref", include this in a funnel visual when I've filtered a s...
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    There isn't really need to make DAX for this since BLANK values and certain Task sets can be filtered in visuals:

    Example:



    End result (note the filters on visual):

     

    However, if you insist on dax you can create a calculated column or filter measure and use that for filtering. E.g.

    Filter column = IF('Example (2)'[Task Set]="Quick Quote"&&'Example (2)'[Opportunity Ref]<>BLANK(),1,0)
     

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!




v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, 

Have you followed the DAX formula and method posted by ValtteriN to find the solution to your problem?

 

If so, would you like to mark his reply as a solution so that others can learn from it too?

 

Thanks in advance!

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.