Forum Discussion
Helper IVchange Total value to a calculated value for 1 column only
Ok we are going to end up creating those Measures...
Bear in mind I don't know what names Measures and Columns you have so you may have to change the names of the Measures
Net Income $ = SUM(powerBIData[NI $])
Overall Revenue = SUM(powerBIData[Total Revenue])
Net Income % = DIVIDE([Net Income $], [Overall Revenue])
Now place Net Income $ and Net Income % in your table and you'll see them broken down by group and correct totals on the bottom.
EDIT: I think you have an extra ) in the previous formula that was giving you error.
Helper IV
I am getting too many arugments error:
Community ChampionOk we are going to end up creating those Measures...
Bear in mind I don't know what names Measures and Columns you have so you may have to change the names of the Measures
Net Income $ = SUM(powerBIData[NI $])
Overall Revenue = SUM(powerBIData[Total Revenue])
Net Income % = DIVIDE([Net Income $], [Overall Revenue])
Now place Net Income $ and Net Income % in your table and you'll see them broken down by group and correct totals on the bottom.
EDIT: I think you have an extra ) in the previous formula that was giving you error.
- kfschaefer
ok we are getting close, how do I change the percentage to display a percent in a measure?
- kfschaefer
nevermind, I figure that out and thank you so much spending your Saturday helping me.
- Sean