Creating a matrix or table from a measure

[eheres]

Hi All,

Im new in Power bi, hope you can help me. I want to create a summary table from a measure because when i remove a dimension (fleet) it repeats the value for all the other dimension.

in summary the issue is that i have to calculate the incremental values for each fleet, but the fleets change its owner. So in a normal way i have Current month - prior month. The problem is when i add the owners or sales rep by month.

i got the split like total incremental = 0 but by sales rep 5 and -5 i only want the total incremental 

please find attached the PBI file

https://elementfinancialcorporation-my.sharepoint.com/:u:/g/personal/eheres_elementcorp_com/EXwQACcg...

for example

 the correct numbers of result are 

[Anonymous · Accepted solution]

Hi @eheres ,

The link shows 'User not in directory.' and I can't download the pbix file.

I made a sample for testing.

For aa, you can create a measure like this.

aa = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="aa")

The same goes for ag and cc.

ag = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="ag")

cc = CALCULATE(SUM('Table'[absolut incremental]),'Table'[Sales Rep Sic ]="cc")

Then drag the measures into the table visualization along with the [Custom] column.

Attach the pbix file for reference.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data