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, belows are my screenshot of my dataset. I'm asked to create a measure to calculate the sum of the revenue of each region regard to it's source and type. So i will put this measure as the value in the matrix table. Is there anyway to do this? By doing this measure, so i wont have to create a slicer for the source and type?
Solved! Go to Solution.
@CTan42 so are you saing you want to hard code each measure by source and type?
ie.
A AR Revenue = calculate(sum(revenue), source = "a", type = "AR")
?
Proud to be a Super User!
@CTan42 so are you saing you want to hard code each measure by source and type?
ie.
A AR Revenue = calculate(sum(revenue), source = "a", type = "AR")
?
Proud to be a Super User!
@CTan42 that would be the correct way to create the measure, is there a lot of measures to create?
how will you display the data, what do you want to do with it?
Proud to be a Super User!
@vanessafvg thx for your help...it works! So basically i will create few matrix tables to display each source & type revenue. Tbh this is just a fake data. My real data is bigger size than these screenshot shown. Thanks your help again.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |