Dax

[Yashodhan]

How to Count Two Specimen in One column with Meansure ?

[Anonymous]

Hi @Yashodhan ,

I create some sample data for reference。

Then create the measure.

Count Measure =
CALCULATE (
    COUNT ( 'Table'[Specimen] ),
    FILTER ( 'Table', [Specimen] = "Specimen 1" || [Specimen] = "Specimen 2" )
)

The result is as follows.

Best Regards,

Stephen Tao

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

[amitchandak]

@Yashodhan ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

example 

Specimen 1=

countrows(Table, Table[Specimen] = "Specimen 1" ))

Specimen 2=

countrows(Table, Table[Specimen] = "Specimen 2" ))

[Yashodhan]

Suppose in onne colum there are two Criteria:

New , Old 

so I have to calculate New and Old 

[Anonymous · Accepted solution]

Hi @Yashodhan ,

Try this

Count New = 
CALCULATE (
    COUNT ( 'Table'[Criteria] ),
    FILTER ( 'Table', [Criteria] = "New" )
)

Count Old = 
CALCULATE (
    COUNT ( 'Table'[Criteria] ),
    FILTER ( 'Table', [Criteria] = "Old" )
)

Best Regards,

Stephen Tao

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