Forum Discussion

carlochecchia's avatar
carlochecchia
Advocate I
9 years ago
Solved

Calculation on PowerBI

Hi All,   I was wondering if anyone could help me with a simple Calculation on my Dashboard. I have the following table:                          I was trying to create a calcul...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    carlochecchia

     

    Hi, try with this:

     

    CountPeople =
SUMX (
    SUMMARIZE (
        Table2,
        Table2[Date],
        "DC";  DISTINCTCOUNT ( Table2[Name] )
    ),
    [DC]
)

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

carlochecchia

 

Hi, try with this:

 

CountPeople =
SUMX (
    SUMMARIZE (
        Table2,
        Table2[Date],
        "DC";  DISTINCTCOUNT ( Table2[Name] )
    ),
    [DC]
)

Regards

 

Victor

Lima - Peru

carlochecchia's avatar
carlochecchia
Advocate I
9 years ago

Vvelarde

 

It worked. Thank you so much!

Best Regards