SUM + measure

[chestercas]

Hi,
I need help for a really simple calcul but I don't find the answer... I tried many things.
I create a measure for DISTINCTCOUNT a value. And with this, I need to include the distinct count (with filter) and the total.
For example :

My measure "compte CC" =

DISTINCTCOUNT('Activites detaillees des consei'[Name])

And I need to DIVIDE to the total (ex for IDF FC : 6/69)
Attention : there's some filter to select (date/hour) and all is dynamic...

Can you help me please ...? I tried with SUM but it don't takes measure...

Thank you !

[GabrielRomaoG]

Hi,

you can try this to make the division:

VAR varCompteCC_all_Site = 

CALCULATE(
       [Complet CC],
       ALLSELECTED(Site)
)
RETURN
DIVIDE([Compte CC], varCompetCC_all_Site)

,
this CALCULATE with ALLSELECTED will ignore the context of the Site column and will return the total (69) for all Sites. 

[chestercas]

Hi,
Thanks for your answer !
It doesn't works, I think it takes the same result of [Compte CC]. So the result is 1 (69/69 or 6/6...)

Finally I do it with Excel... Thank you