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

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