Forum Discussion

ksobota's avatar
ksobota
Regular Visitor
10 years ago
Solved

DAX Function for COUNTIF and/or CALCULATE

Hello,   I am fairly new to Power BI and am even newer to the use of DAX functions. For years I have worked in Excel and know how I would do this there, but am finding the same formula I would use ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    10 years ago

    Hi ksobota,

     

    Based on your scenario, you can use the DAX below on your INDIVIDUAL table.

    CountUser = CALCULATE(COUNTA(EMPLOYMENTS[Member_C]),FILTER(ALL(EMPLOYMENTS),EMPLOYMENTS[Member_C]=INDIVIDUAL[User_ID]))

     

     

    Regards,

    Charlie Liao

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi All,

 

I am looking for the similar query. I have created a calculated columns in Power BI. 

 

We need to calculate “total shipment count” in Power BI. For calculating total shipment count we need to apply two conditions:

 

  1. If the “Plant_Shpto_Shpment_Gross KG” is 0 then shipment count will be 0.
  2. Secondly, we have to compare the consecutive rows of the “Plnt_Ship-to_Shpmt_Mat” column. Please refer the snapshot below to view the formula used to get the desired shipment count in Excel. If the values in the consecutive rows are same, it should return 0 as shipment count

  3. I have used following formula in power BI but its showing error.

     

     

    DAX FormulaCan someone please help me to get the output.

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for prompt reply.

 

I tried to change the data type but due to "0101_150190142_DRX0062220_1720.91" type of values it's giving error as "Cannot convert value '0101_150190142_DRX0062220_1720.91' of type Text to type Integer".

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Then that's not the column you have to sum. Find the column where you have the numeric value.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      ok.. actually i want to find "toal shipment" for particular plant & Material and rest other calculations are based on that shipment count. Instead of using SUM i tried using Count/Distinct but it's not giving correct output. I am also trying to find out the other way. 

      Thanks :-)