Forum Discussion

Frequent Visitor

4 years ago

Solved

Dax

How to Count Two Specimen in One column with Meansure ?

Frequent Visitor

4 years ago

Suppose in onne colum there are two Criteria:

New , Old

so I have to calculate New and Old

Anonymous

Not applicable

4 years ago

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.