Count problem measure

[Anonymous]

Good morning, everyone,
I am creating a Dax command, which allows calculating the number of category A (which is in the Category column) that have a Success in the Result column. So the result after creating this measure is 4. Here is the illustration to understand more. PS: There are a lot of data like these. 

Best regards. Thank you. 

[Anonymous · Accepted solution]

@Anonymous  - 

If you want it to be specific for Category A, you can create this measure:

Count Success Category A = 
CALCULATE(COUNTROWS(YourTable), YourTable[Category] = "A", YourTable[Result] = "Success")

You could also create your measure to work more generally:

Count Success = 
CALCULATE(COUNTROWS(YourTable), YourTable[Result] = "Success")

Hope this helps,

Nathan

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use DAX Expression below

Measure 4 = 
CALCULATE(
    COUNTROWS( Table ),
    Table[Result] = "Success"
)

Regards,
Mariusz

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

[Anonymous · Accepted solution]

@Anonymous  - 

If you want it to be specific for Category A, you can create this measure:

Count Success Category A = 
CALCULATE(COUNTROWS(YourTable), YourTable[Category] = "A", YourTable[Result] = "Success")

You could also create your measure to work more generally:

Count Success = 
CALCULATE(COUNTROWS(YourTable), YourTable[Result] = "Success")

Hope this helps,

Nathan