Calculation on PowerBI

[carlochecchia]

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 calculated measure that would SUM, the DISTINCTCOUNT of WORKERS, per day..

Something like this:

I am looking for a DAX formula that would give me a total of 7.

Thanks in advance

Carlo

[Vvelarde · Accepted solution]

@carlochecchia

Hi, try with this:

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

Regards

Victor

Lima - Peru

[carlochecchia]

@Vvelarde

It worked. Thank you so much!

Best Regards