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.
Community ChampionIf you have the right Measures the Total % what you are looking for 6.7% will show up in the Total Row!
It will not be a sum of the whole column? Have you worked with Pivot Tables before?
Helper IVI need to have the total value for the following calculation:
DIVIDE(PctNITotal[totalNI$],PctNITotal[totalRevenue]) = 6.6% for 2015 or a running calcuation the recalcs when slicers is selected See picture in last post, the Measure was just so I can illustrated the value I wanted in the total row.
- Sean
You CANNOT put a different Measure in the Table just in the Total Row under NI% per Group where you want that 6.7% to show up
You should not have columns NI $ per Group and NI% per Group but rather just NI $ and NI % (with no filters)
The Group Name Column will filter the results
And then you you will get the Totals you desire on the bottom
- kfschaefer
Those are the labels given to me by my client, still confused, If Sum the % it gives me the extremely high value. What do I used instead of Sum?
What would the Measure look like, I never really used them before. and how will that effect the total value?
- Sean
So the data they gave you is already calculated for each Group?
all the numbers in the NI$ per Group and NI% per Group columns are given to you - you don't calculate them
Post a picture from the Report View of the Fields from the table where these 2 columns are
- kfschaefer
here is my effort without success:
- Sean
kfschaefer to get NI% you divide NI by Revenue
NI% = DIVIDE ( SUM(powerBIData[NI $], SUM(powerBIData[Total Revenue]) )
if you place this measure next to NI% by Group - for each Group you should get the same result AND the Total should be your 6.7%