Forum Discussion

ChanelZheng's avatar
ChanelZheng
Frequent Visitor
6 years ago
Solved

Silcer Value Calculation

Hello,   I am trying to work out why a chart is not showing the correct value as it should be:   I created a table with a single column called "silent year" and a year slicer   Annu...
Need Help
  • ChanelZheng's avatar
    ChanelZheng
    6 years ago

    Thanks for the reply. 

     

    I gave it a go but still no luck. The dax is as follow:

    AnnualSilentPG = var spg =  COUNT(SilentPhase[SilentYear])
Return ([Total] * PGContribution[PGContribution Value] * PublicContribution[PublicContribution Value]) / spg

    The chart remain the same with 155M...:smileymad:

  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi ChanelZheng 

    Create relationships

     

    Create measures

    Measure(a*b) = SUM(PGContribution[value1])*SUM(PGContribution[value2])

Measure(divide) = [Measure(a*b)]/CALCULATE(COUNT(SilentPhase[year]),ALLSELECTED(SilentPhase))

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi ChanelZheng 

Is this problem sloved? 
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
 
Best Regards
Maggie