dimanche 24 novembre 2019

Counts of Rows : (SOME IF CONDITION)+(SOME IF CONDITION) this is the requirement DEX Power BI calculation field

enter image description here

Here I am putting the formula: Calculate(Count(IF([Condition Type]= "ZMAN" && ([Condition Status] = "Inactive",1))+Count(IF([Condition Type]= "PR00" && ([Condition Status] = "Active",1)) )

Aucun commentaire:

Enregistrer un commentaire