Forum Discussion

daedah's avatar
daedah
Helper II
6 years ago
Solved

repeat maintenance

Hi I tring to calculate DAX measure for power bi ,calculate repeat maintenance by machine_name and Reason in month Example data Date                                Machine_name                    ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    daedah it should be a simple measure and then whatever slicer you use the count will change, in this case you will on Nov, 2019 and the measure for count is:

     

    Maintenance Count = COUNTROWS ( YourTable )

     

  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    daedah 

     

    Simply drag the fields and measure above to a Table visual. A measure always operates on aggregations of data under the evaluation context.

     

parry2k's avatar
parry2k
Super User
6 years ago

daedah it should be a simple measure and then whatever slicer you use the count will change, in this case you will on Nov, 2019 and the measure for count is:

 

Maintenance Count = COUNTROWS ( YourTable )

 

  • daedah's avatar
    daedah
    Helper II
    6 years ago

    Thank you for you help 🙏    but I want  to count in condition same reason and same machine_name when I select slicer (Year , Month)

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      daedah yes it will work, if I'm missing something, please explain further in detail.

      • daedah's avatar
        daedah
        Helper II
        6 years ago

        Example data

        Date                                Machine_name                             Reason
        1/11/2019                        A                                                  Person

        2/11/2019                        B                                                   spare part

        3/11/2019                        A                                                   Person

        10/11/2019                      C                                                    Using

        12/11/2019                      B                                                    spare part

        1/12/2019                        A                                                    person

         

        Result of November 
        Machine_Name       count of maintenance by month

        A                                2  (2 from   ----- > 1)  1/11/2019 - Person   2) 3/11/2019 - Person  )

        B                                2  (2 from   ------> 1) 2/11/2019 - spare part  2) 12/11/2019 - spare part

        C                               1   (1 from  -------> 1) 10/11/2019 - Using