Forum Discussion

rabah's avatar
rabah
New Member
3 years ago
Solved

var = union

Nbr Clients Stratégique =

CALCULATE(
DISTINCTCOUNT(unionFactureBon[ID_CLIENT]),
CLIENT[BOOL_STRATEGIQUE] = TRUE()
)

 

VAR unionFactureBon =
                              UNION(
                                SUMMARIZE(FACTURE_VENTE, FACTURE_VENTE[ID_CLIENT], FACTURE_VENTE[DATE_FACTURE]),
                               SUMMARIZE(FILTER(BON_LIVRAISON, ISBLANK(BON_LIVRAISON[DATE_FACTURE])),

                                           BON_LIVRAISON[ID_CLIENT], BLANK()) 
                              )

  • Your syntax is the wrong way round

     

    Table = 

    var tempvariable = something

    return union(tempvariable, tempvariable)

1 Reply

  • Your syntax is the wrong way round

     

    Table = 

    var tempvariable = something

    return union(tempvariable, tempvariable)