HOW can I achieve this result ?

Question

ChannelÂ&nbsp;Benfit designÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Desired Result&nbsp;&nbsp;AopenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;channelÂ&nbsp;OpenÂ&nbsp;closeÂ&nbsp;AopenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a100%&nbsp;AopenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B40%60%AopenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c50%50%BClose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BClose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BopenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BopenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BClose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CClose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CClose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COpenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COpenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COpenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COpenÂ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-cherch-msft · Accepted Answer

Hi&nbsp;pgarg&nbsp;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&nbsp;Regards,Cherie

Forum Discussion

HOW can I achieve this result ?

1 Reply

Related content

TOP Achiever Analysis

Download cypher results

No results

Need guidance on achieving desired filter results

Percentage achievement

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Â