How to calculate a % of stores that have two different codes

[bcbuckley13]

Hi PBI Community...TIA !!

I have a report (TEST A) that gives me a list of restaurants and two different deviations. (x and y). I'm trying to do the calculation for when a restaurant has both. When I run this code, the result is too high. Any ideas?

% of restaurants with glove AND mask deviation = DIVIDE(CALCULATE(count('TEST A'[Store ID]),'TEST A'[Code] = "x") + CALCULATE(count('TEST A'[Store ID]),

'TEST A'[Code] = "y"),count('TEST B'[Store ID]))

[mhossain]

Hi @bcbuckley13 

Try this % of restaurants with glove AND mask deviation =
DIVIDE(
CALCULATE(count('TEST A'[Store ID]),'TEST A'[Code] = "x"||'TEST A'[Code] = "y"),
count('TEST B'[Store ID]))

In the Test A table do you have duplicate enteries?Do you want to count duplicate or disctinct? Please adjust above dax accordingly. Please let me know if this works.