Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
for example
the correct numbers of result are
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |