Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX Filtering and Identifying Multiples Across an Attribute

Relativly new to DAX and would appreciate any input.  I have data that looks like the below and I have a sclicer on Event_Type.  I want to filter on multiple Event_Types and then be able to filter to...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

If I understand correctly, the issue is that you want to filter on multiple Event Types. Please try the following methods and check if they can solve your problem:

1.Create the simple Table and Table 2. 

 

2.Add Create a measure 2. Enter the following DAX formula.

Measure 2 = 
var tmp=SELECTCOLUMNS('Table 2',"ET",[Event_Type])
var _str=CONCATENATEX(tmp,[ET],",")
var _a=SELECTEDVALUE('Table'[Audited])
var _b=SELECTEDVALUE('Table'[Invoiced])
var _c=SELECTEDVALUE('Table'[Event_Type])
return
IF(ISFILTERED('Table 2'[Event_Type]),IF(CONTAINSSTRING(_str,_c)&&_a="Y"&&_b="Y",1),1)

3.Move measure 2 to the filters.

 

4.Select the slicer visual and move the Table 2 Event_Type to the slicer.

5.Select the Emergency and Urgent, the result is shown below.

Looking forward to your reply.

Best Regards

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi.  Thanks for the reply.  The idea is that the user will select two or more Even_Types.  Then they would like to further filter to only include records that occure more than once within an given Event_ID for the selected Event Types. 

    I was thing of creating a column (like CountInEvent) that would calculate and update based on the even_type selection and then using that as a filter.  

    The key point is that if the user changes the Event_Types selected (via a slicer) the CountInEvent should change.

     

    This would be what it would look like without filters.

     

     

    If I filtered on Emergency and Routine it would look like the below (Since only these values have Audited and Invoiced set to Y)

     

    Then I would filter on CountInEvent to only get values greater than 1.