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.

     

4 Replies

  • 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.

         

  • 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.