Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Please share a measure if possible a file with dummy data.
@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)
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!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |