Forum Discussion

POWER_MI's avatar
POWER_MI
Post Patron
5 years ago
Solved

Need help

Hi, 

is it possible to define mesure to use on power BI to calculate 

 

The number of row wich egalement on table at status ='' OK"

 

the table ( excel data base)  have rows:

Project  ( project 1, project 2....

users

status ( Ok, KO, NO..)

..

 

the objectif is to have on power bi dashbord 

 

                   Project 1                                        Project 2       .....

ROWS         Number of rows ( Status OK)        Number of rows ( Status OK)

can you send mesure to take thanks

all rows of project by project which having status OK( Number of rows OK project by projetct)

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi POWER_MI,

    #1, You can put '+0' to your formula to force display all rows:

     

    Nombre K0 =
CALCULATE ( COUNTA ( 'Feuil1'[status] ), 'Feuil1'[status] IN { "K0" } ) + 0

     

    #2, I'm not so clear about your description, did you means only export projects that contain particular status? 

    Regards,

    Xiaoxin Sheng

3 Replies

  • manikumar34's avatar
    manikumar34
    Solution Sage
    5 years ago

    POWER_MI , 

    Not clear, 

     

    use something like this and check the Answer. 

     

    If(table[Status]="Ok",COUNT(table[Project]),0)

     

    after writing this measure use Matrix table to show Project wise count.

     

    regards, 

    Manikumar

    If you think this is helpful Accept as a soltion and leave a like.

    • POWER_MI's avatar
      POWER_MI
      Post Patron
      5 years ago

      thanks for answer

      i used this mesure and it work i have just not able to take blank or empty rows

      Nombre K0 =
      CALCULATE(COUNTA('Feuil1'[status]), 'Feuil1'[status] IN { "K0"})
       
      project 1 project 2 project 3
      OK 5 2
      KO if not row this row will not displayed on results so how to add also '0' Ko row for projects
      Unknown

       

       

      also for Project 1 we have 5 OK   how to export just this 5 Rows ?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi POWER_MI,

        #1, You can put '+0' to your formula to force display all rows:

         

        Nombre K0 =
CALCULATE ( COUNTA ( 'Feuil1'[status] ), 'Feuil1'[status] IN { "K0" } ) + 0

         

        #2, I'm not so clear about your description, did you means only export projects that contain particular status? 

        Regards,

        Xiaoxin Sheng