Forum Discussion

Yashodhan's avatar
Yashodhan
Frequent Visitor
4 years ago
Solved

Dax

How to Count Two Specimen in One column with Meansure ?
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.