Substract Total count from specific event

[ashuaswinireddy]

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!

[ashuaswinireddy · Accepted 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

[RossEdwards]

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

[ashuaswinireddy]

Yes, I am looking this type of logic for multiple events to create burndown chart

[Anonymous]

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!