Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dax Calc countif

I need help figuring out how to write this formula in dax.    COUNT IF [F RETAIL FH FIRST/FURTHER] = "FIRST" OR "FURTHER"
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Text is not computable for aggregation, I think you need to convert the data type first.

    Through here to change the data type:

    and then you can do some calculation.

    Refer to my pbix file for better understanding.

     

    Best regards,

    Community Support Team Selina zhu

    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
3 years ago

Thanks for the answer, but that syntax does not work.

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
3 years ago

What's the error?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I dont think and if will work for dax.  I am just looking to COUNT [F RETAIL FH FIRST/FURTHER] when its  = to "FIRST" OR "FURTHER"

    • ERD's avatar
      ERD
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Ok, here is another option:

      your_measure =
CALCULATE (
    COUNT ( 'F RETAIL FH FIRST'[FURTHER] ),
    'F RETAIL FH FIRST'[FURTHER] IN { "FIRST", "FURTHER" }
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thats not getting me the answer I need.  below is the calc I am trying to convert from qlik to pbi.  The RTL_First_further is text if that helps.

        sum(if(RTL_FIRST_FURTHER = 'FIRST',1,
        if(RTL_FIRST_FURTHER = 'FURTHER' ,1,null())))