generate new table with a new measure

[eheres]

Hi All,

Hope you can help me, i create a measure that depends in a column. the thing is when i remove that dimension my measure put the same amounts in all rows and i have to present only one dimension in the report (Sales rep). I dont know if a summarize or group by function can help me with the solution

Here is the example

here is what happen when i remove a the fleet dimension

Thank you!

[RAZP]

Please share a measure if possible a file with dummy data.

[amitchandak]

@eheres , does not seem like a power bi output. Can you please share the measure?

And I am hopeful, you are creating a Matrix(not a calculated table)

[eheres]

Hi @amitchandak ,

First let me explain the main problem, I have to calculate the absolut incremental by type to then multiply to a binari matrix to have it by sales rep, this is because they exchange fleets between them and if i calculate the normal incremental i got -1000 + 1001 between sales rep but the total absolut incremental of the fleet is 1

please find attached the file in excel First try automation v21.xlsx

Thank you!