On utilise la fonction ValueList()
If not, let me introduce you to ValueList() and its number oriented big brother ValueLoop().
ValueList (value {, value })
Calcul de la dimension:
=ValueList(‘My First KPI’,’My Second KPI’)
Expression:
=IF( ValueList(‘My First KPI’,’My Second KPI’)=’My First KPI’,
Sum([My First KPI Field],
Count([My Second KPI Field])
)





![[PowerBI][DAX] – Comment gérer les espaces et les champs vides ?](https://i1.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/01/powerbi-dax-isblank.png?resize=218%2C150)



![[PowerBI][DAX] – Comment compter le nombre de ligne d’une table ?](https://i2.wp.com/mybicoach.bwabwanet.fr/wp-content/uploads/2020/01/powerbi-dax-countrows-logo-1.png?resize=100%2C70)