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.
Hello All,
I have below Data
Number | Category | Event |
123 | UN | MV1 |
124 | UN | MV2 |
128 | IM | MB1 |
129 | IM | MB2 |
137 | FE | MB1 |
189 | IM | MB2 |
190 | UN | SO |
198 | FE | PO |
200 | IM | No |
Total Number=count(number)=9
Total MB1=count(MB1)=2
Total MB2=count(MB2) =2
Total SO=Count(SO)=1
I need to substract total Number -specific events.
I am looking for a way to get below output.
Total Number | Total Number - MB1 | (Total Number-MB1) - MB2 | ((Total Number-MB1) - MB2)-SO |
9 | 9-2=7 | 7-2=5 | 5-1=4 |
Please let me know how can I get this.
Thank you!
Solved! Go to Solution.
Creating aggregated table referencing below link helped resolving my issue
https://community.fabric.microsoft.com/t5/Desktop/Create-new-table-using-another-table/m-p/3604179
Creating aggregated table referencing below link helped resolving my issue
https://community.fabric.microsoft.com/t5/Desktop/Create-new-table-using-another-table/m-p/3604179
This could be the type of method you are looking for?
Total Number = COUNTROWS('Example')
Total Number - MB1 = var totalNumber = [Total Number]
var MB1 = CALCULATE(
[Total Number],
'Example'[Event] = "MB1"
)
RETURN
totalNumber - MB1
Yes, I am looking this type of logic for multiple events to create burndown chart
Hi, @ashuaswinireddy
Have you solved your problem? If so, mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
User | Count |
---|---|
81 | |
76 | |
69 | |
68 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |