I need help with DAX. I need to calculate record id's if values in two different columns=1

[Anonymous]

	Table A						MESURE-x
Record id	Col A	FILTER1	FILTER2				COUNT RECORD IDs
A		1	1
A		1	0				1
B		1	1
C		1	1
C		1	0
D		1	0				1
E		1	0				1
							3

The table has two filter columns, I need to count record IDs that would match to the Mesure x

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

Try the measure :

test = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[FILTER1]+'Table'[FILTER2]=1))

Please note that according to your description of the logic, the result is 4 ( not 3) because record ID "c" meets the condition too.

Link to the sample file 

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

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

Try the measure :

test = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[FILTER1]+'Table'[FILTER2]=1))

Please note that according to your description of the logic, the result is 4 ( not 3) because record ID "c" meets the condition too.

Link to the sample file 

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

[Ritaf1983]

@Anonymous 
Happy to help, please consider Accepting my response as the solution to help the other members find it more quickly. 
(you marked your response )

[Anonymous · Accepted solution]

Yes, I agree, thank you so much!