If SelectedValue has a positive value in both columns within matrix

[nckpedersen]

Need some help on grid calculations. Given the matrix below, how can I retrieve values that have a positive count in both 2022 and 2023 (Crowdstrike both DEN and DGN = 1, Crowe DGN = 1, ICA = 0, Data Storage DGN = 0):

Sample data below. 

Id	Name	Group	Date
abc123	Data Storage Corporation	DGN	2022
abc124	Dajani Consulting Inc.	ICA	2023
abc125	Dajani Consulting Inc.	ICA	2022
abc126	Datadog Inc	ICA	2023
abc127	Crowe LLP	ICA	2022
abc128	CrowdStrike Inc	DEN	2022
abc129	CrowdStrike Inc	DEN	2023
abc130	Crown Castle International Corp.	DEN	2023
abc131	Crown Castle International Corp.	DEN	2022
abc132	Crown Castle International Corp.	DGN	2023
abc133	Crown Castle International Corp.	DGN	2022
abc134	Datadog Inc	DGN	2022
abc135	Data.World	DGN	2022
abc136	CrowdStrike Inc	DGN	2022
abc137	CrowdStrike Inc	DGN	2023
abc138	Crowe LLP	DGN	2023
abc139	Crowe LLP	DGN	2022

[nckpedersen · Accepted solution]

Found the answer using variables:

21/22 YoY =

    var count_2021 = calculate(count('Purchases'[Id]),year('Purchases'[CloseDate])=2021)

    var count_2022 = calculate(count('Purchases'[Id]),year('Purchases'[CloseDate])=2022)

return

    if(count_2021 > 0 && count_2022 > 0, 1, 0)