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.
Need to get the rate column as a result.The total columns in dollars as condition should be divided by total of sales.
category | nsub-cat | condition | total | rate |
Blank | z | sales | 8 | |
car | A | Dollars | 45 | 5.625 |
car | B | Dollars | 65 | 8.125 |
car | C | Dollars | 77 | 9.625 |
Bike | D | Dollars | 67 | |
Bike | E | Dollars | 78 | |
Bike | F | Dollars | 95 | |
Bike | G | Dollars | 88 | |
Bike | H | Dollars | 67 |
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Hi thanks for the solution , but i just couldn't compare with my data .pls look at the modified question
Do you have only car or many groups in your category column?
if there are many groups, then please post an example of several groups.
Yes i do have many groups but those shouldn't have the rate nos
that is, apply the calculation only to car, and show it empty to the rest?
this means that there are a lot of Sales, then how will we know that 8 belongs to the car group?
show an example of 2-3 groups
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |