Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate rate for specific regions

Hi, I'm quite fresh to Power BI so sorry if this was alredy created but i have issue/question   lets assume i have data like: Regioons/Country/Revenue and want to calculate % of revenue for given ...
Need Help
Tips and Tricks
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    Do you mean this?

    Measure =
VAR region =
    CALCULATE ( SUM ( 'Table'[REVENUE] ), ALLEXCEPT ( 'Table', 'Table'[REGION] ) )
RETURN
    DIVIDE ( SUM ( 'Table'[REVENUE] ), region )

     

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

Do you mean this?

Measure =
VAR region =
    CALCULATE ( SUM ( 'Table'[REVENUE] ), ALLEXCEPT ( 'Table', 'Table'[REGION] ) )
RETURN
    DIVIDE ( SUM ( 'Table'[REVENUE] ), region )