Filter a date table with rows that have a value on January

[prebenolsen]

Hi, 

I'll try to better explain the title here:

I have a dataset as you can see below (sample). 

I want to create a visual (barchart, table) shows the frequency of positive and negative for each month, for each ID.

The visual should only include rows that have a value in January. 

In the sample data, ID 1 and 2 both have values for January. ID 3 does not.

The visual should exclude ID 3, and present ID 1 and 2s positive and negative values for all months. 

ID	Month	Positive	Negative
1	January	4	5
1	February	5	4
1	March	7	3
1	April	10	2
2	January	7	7
2	February	8	3
2	March	10	1
2	April	12	1
3	February	5	5
3	March	5	4

Is there an easy way of doing this, or is complex DAX required? 

[tackytechtom · Accepted solution]

Hi @prebenolsen,

I have a solution here:

I created a calcualted column so I could use it in the visual as a filter:

The code is as follows:

IDContainsJanuaryFilter = 
VAR _list = 
    SUMMARIZE (
        FILTER (  Table12, Table12[Month] = "January"  ),
        [ID]
    )
RETURN
IF ( Table12[ID] IN _list, 1, 0 )

Does this work for you? 🙂

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom