HOW can I achieve this result ?

[pgarg]

ChannelÂ	Benfit designÂ					Desired Result
A	openÂ					channelÂ	OpenÂ	closeÂ
A	openÂ					a	100%
A	openÂ					B	40%	60%
A	openÂ					c	50%	50%
B	Close
B	Close
B	openÂ
B	openÂ
B	Close
C	Close
C	Close
C	OpenÂ
C	OpenÂ
C	OpenÂ
C	OpenÂ

[v-cherch-msft · Accepted solution]

Hi @pgarg

You may try to create a measure as below:

Measure 3 =
VAR a =
    CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1[Benifit] ) )
VAR b =
    COUNTROWS ( Table1 )
RETURN
    b / a

Regards,

Cherie