Forum Discussion

Marifah's avatar
Marifah
New Member
6 years ago
Solved

graph interactions with DISTINCTCOUNT/average function

**not all tables,columns and fields are here to stay. These pictures were taken just I was messing around and trying stuff. Hey everyone ^^ I'm quite new to the powerbi/query re...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Marifah ,

     

    Please update your measure as below.

    Ortalama 1 = CALCULATE(SUM(Liste[Karşılaştırma - 1]),ALLEXCEPT(Liste,Liste[Odeme]))/DISTINCTCOUNT('AyTablo'[YA])
    Ortalama 2 = CALCULATE(SUM(Liste[Karşılaştırma - 2]),ALLEXCEPT(Liste,Liste[Odeme]))/DISTINCTCOUNT('AyTablo2'[YA])

     

  • Marifah's avatar
    Marifah
    6 years ago

    Thanks for the reply!


    This was not updating the Total.
    I've just added AyTablo[YA] to the ALLEXCEPT in order to let the Total change as well.

    As below:

    Ortalama 1 = CALCULATE(SUM(Liste[Karşılaştırma - 1]);ALLEXCEPT(Liste;Liste[Ödeme Kategorisi];AyTablo[YA]))/DISTINCTCOUNT('AyTablo'[YA])



Ortalama 2 = CALCULATE(SUM(Liste[Karşılaştırma - 1]);ALLEXCEPT(Liste;Liste[Ödeme Kategorisi];AyTablo2[YA]))/DISTINCTCOUNT('AyTablo2'[YA])



v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Marifah ,

 

Please update your measure as below.

Ortalama 1 = CALCULATE(SUM(Liste[Karşılaştırma - 1]),ALLEXCEPT(Liste,Liste[Odeme]))/DISTINCTCOUNT('AyTablo'[YA])
Ortalama 2 = CALCULATE(SUM(Liste[Karşılaştırma - 2]),ALLEXCEPT(Liste,Liste[Odeme]))/DISTINCTCOUNT('AyTablo2'[YA])

 

Marifah's avatar
Marifah
New Member
6 years ago

Thanks for the reply!


This was not updating the Total.
I've just added AyTablo[YA] to the ALLEXCEPT in order to let the Total change as well.

As below:

Ortalama 1 = CALCULATE(SUM(Liste[Karşılaştırma - 1]);ALLEXCEPT(Liste;Liste[Ödeme Kategorisi];AyTablo[YA]))/DISTINCTCOUNT('AyTablo'[YA])



Ortalama 2 = CALCULATE(SUM(Liste[Karşılaştırma - 1]);ALLEXCEPT(Liste;Liste[Ödeme Kategorisi];AyTablo2[YA]))/DISTINCTCOUNT('AyTablo2'[YA])