Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |