How to calculate proportion in each subcategory of a larger category

[OPS-MLTSD]

Hello, I am trying to count the proportion of events in each category exactly like what this persion has done in this tutorial: https://bielite.com/blog/calculating-percent-of-subtotal/

Youtube link to the same tutorial: https://www.youtube.com/watch?v=AJxCCfFmLTQ

I followed their guideline and tried to create a measure for my visual, however, I am getting an error, I have posted my calculation at the bottom, if someone could please help me fix this error, that would be much appreciated. 

Event Proportion % =

VAR Groupall = VALUES(Group[Group])

VAR categorytype = VALUES('Events'[categorytype])

VAR categoryname = VALUES('Events'[categoryname])

VAR eventcount = DISTINCTCOUNT('Events'[EventID])

VAR eventnames =

SWITCH(

TRUE(),

ISINSCOPE('Events'[event name]),CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED(Group), Group[Group] IN Groupall, ALLSELECTED('Events'), 'Events'[categorytype] IN categorytype, 'Events'[categoryname] IN categoryname),

ISINSCOPE('Events'[categoryname]), CALCULATE(DISTINCTCOUNT('Events'[EventID),ALLSELECTED(Group), Group[Group] IN Groupall, ALLSELECTED('Events'), 'Events'[categorytype] IN categorytype),

ISINSCOPE('Events'[categorytype]), CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED(Group), Group[Group] IN Groupall),

ISINSCOPE(Group[Group]),CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED(Group))

)

RETURN

IF(

ISINSCOPE(Group[Group]),

DIVIDE(eventcount, eventitems),

1

)

[OPS-MLTSD · Accepted solution]

I was able to figure out the solution its this:

Event Proportion % =

VAR Groupall = VALUES(Group[Group])

VAR categorytype = VALUES('Events'[categorytype])

VAR categoryname = VALUES('Events'[categoryname])

VAR eventcount = DISTINCTCOUNT('Events'[EventID])

VAR eventnames =

SWITCH(

TRUE(),

ISINSCOPE('Events'[event name]),CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED(Group), Group[Group] IN Groupall, ALLSELECTED('Events'), 'Events'[categorytype] IN categorytype, 'Events'[categoryname] IN categoryname),

ISINSCOPE('Events'[categoryname]), CALCULATE(DISTINCTCOUNT('Events'[EventID),ALLSELECTED(Group), Group[Group] IN Groupall, ALLSELECTED('Events'), 'Events'[categorytype] IN categorytype),

ISINSCOPE('Events'[categorytype]), CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED(Group), Group[Group] IN Groupall),

ISINSCOPE(Group[Group]),CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED(Events),ALLSELECTED(Group))

)

RETURN

IF(

ISINSCOPE(Group[Group]),

DIVIDE(eventcount, eventitems),

1

)

basically I needed to add the allselected filter for the events table as well

[amitchandak]

@OPS-MLTSD , What ever is in scope removefilter for that using all or allselected or removefilters

example

SWITCH(
TRUE(),
ISINSCOPE('Events'[event name]),CALCULATE(DISTINCTCOUNT('Events'[EventID]),ALLSELECTED('Events'[event name])) ,

// add for other

)

no need of in clause if they are already joined with table or part of the same table