Forum Discussion

chestercas's avatar
chestercas
Icon for Helper I rankHelper I
3 years ago

SUM + measure

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 (wit...
Need Help
GabrielRomaoG's avatar
GabrielRomaoG
New Member
3 years ago

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's avatar
    chestercas
    Icon for Helper I rankHelper I
    3 years ago

    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