Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Stacked column chart breakdown with a measure

Hi. I created a stacked column chart to show customer credit (in dollars) over time. On the y-axis are dollars, and on the x-axis is the year. Each bar is broken down by reason the customer was credi...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    Based on my test, you could refer to below fromulas:

    Create a calculated column:

    Create below measure:

    Measure = CALCULATE(SUM(Table1[Credit]))/CALCULATE(SUM(Table1[Column]))

    Result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

     

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous ,

Based on my test, you could refer to below fromulas:

Create a calculated column:

Create below measure:

Measure = CALCULATE(SUM(Table1[Credit]))/CALCULATE(SUM(Table1[Column]))

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He