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.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
    Yashodhan
    Frequent Visitor
    4 years ago

    Suppose in onne colum there are two Criteria:

    New , Old 

    so I have to calculate New and Old 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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.