Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have Master, SalesPerson, Quota, Order and Date fields in a Sales table. I create a hierarchy: Master -> Sales Person. The Sales Persons have quotas and the Master quota is the combined quota of all his/her Sales Person's quotas. I create a measure called "Quota of Sales Person = SUM (Sales(Quota))". I also have a rolling total for the Sales Person and when I put the quota, rolling total for the Sales person I get something like this:
Now, when I try it with Masters, I get this:
I want the quota line to be constant but my quota measure won't work for it. I need help writing a measure for the Masters quota
hard to know with the very little information you have provided.
firstly can you show exactly what fields you have placed where in the visual , provide more screeenshots, where the fields are, what type of axis you have chosen. Please also provide a sample of the data with the measures you have created or ideally the pbix.
Proud to be a Super User!
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |