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 (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 !
 
Need Help

2 Replies

  • 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