Need help

[POWER_MI]

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)

[manikumar34]

@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]

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 ?

[v-shex-msft · Accepted solution]

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