Forum Discussion

Post Patron

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

POWER_MI

Post Patron

6 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

Not applicable

6 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