DAX: identify items that have all three values in second column; excluding items that do not

[jzmqt11]

Hello everyone! 

I am stuck with a problem that I'm sure is easy but for the life of me can't figure out how to work it out with DAX. Here's what I need to do:

• I have three columns, two queried from database (Client ID; Revenue) and the other one is calculated (Revenue Month). Let's call the table "Payments". 
• I need to establish a tag or identify which items in [Client ID] have values "Month 1" AND  "Month 2" AND "Month 3" in [Revenue Month] by way of a second calculated column.  
• The idea is to use this other calculated column in a slicer and see the visualization for the whole dataset and then switch to see only metrics for those items that have revenue data in Month 1,2, && 3.  

I appreciate any help you can offer!

CLIENT ID	Revenue Month	Revenue
128	Month 1	59,218.00
419	Month 1	37,661.00
419	Month 2	14,906.00
742	Month 1	20,597.00
742	Month 2	37,679.00
742	Month 3	69,221.00
1351	Month 1	21,032.00
1351	Month 2	21,895.00
1351	Month 3	38,689.00
1280	Month 1	57,861.00
1280	Month 2	37,969.00
1280	Month 3	63,414.00
1074	Month 1	69,983.00
294	Month 1	51,029.00
294	Month 2	71,499.00
182	Month 1	45,760.00
303	Month 1	40,788.00
303	Month 2	42,413.00

[v-danhe-msft]

Hi @jzmqt11,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

Hi @jzmqt11,

From your description, I could not understand what your desired result, could you want to show a slicer cover the Client ID in multiple months? If so, you could refer to below steps:

Create a new table:

Table = SUMMARIZE('Table1','Table1'[CLIENT ID],"T",CONCATENATEX('Table1','Table1'[Revenue Month],"&"))

Create the relationship and use the [T] coulum as slicer:

Now you could see the result, if I misunderstand you, could you plesase post your desired result if possible, also you could download the pbix file to have a view.

https://www.dropbox.com/s/cawfn3t53kxohhf/identify%20items%20that%20have%20all%20three%20values%20in...

Regards,

Daniel He