Forum Discussion

jonoren's avatar
jonoren
Frequent Visitor
4 years ago
Solved

Many to Many relationship Standard Deviation Calculation

For the example, I have 2 simple tables:  1. Countries Table: CountryID   Name                 CurrencyCode 1 United States USD 2 United Kingdom GBP 3 Canada CAD 4 Germany ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, jonoren ;

    The relationship as follow:

    Then create a measure.

     

    Measure = STDEVX.S(SUMMARIZE('ExchangeRate',[CountryDate],[CurrencyCode],'ExchangeRate'[Value]),[Value])

     

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dhacd's avatar
Dhacd
Resolver III
4 years ago

Hi jonoren  Can you confirm whether the records in the country table are distinct or not?
Regards,
Atma.

jonoren's avatar
jonoren
Frequent Visitor
4 years ago

I just edited the question to reflect they are not distinct

  • Dhacd's avatar
    Dhacd
    Resolver III
    4 years ago

    Hi jonoren  Please check whether you are using the countryside from the country table and the country from the exchange table are used to create a relation.

    If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.

    Thanks and Regards,
    Atma.