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 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

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

2 Replies

  • 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