Users clicked only channel A, Channel B & Both

[johhnybest]

Hi All, I'm fairly new to this tool & I have this data coming from single table where i need to show user clicked only channel A, only channel B & Both (suppose if user clicked on both channels, we should show them under "Both")

-Channel A is a combination of [mobile, tablet] clicks (which is coming from "device" column) 

-Channel B would be clicks from Browser(derived from "device" column)

Expected result: 

ChannelType	UserCount
Channel A (mobile, tablet)	xx
Channel B (Browser)	xx
Both	xx

Thank you in advance! 🙂

[johhnybest]

Thank you @v-zhengdxu-msft  for the response. I tried but it gives me same count for all users.

For better understanding, Please see below on what is expected.

thank you!

[johhnybest]

@amitchandak could you please help here that would be greatly appreciated. 

[v-zhengdxu-msft]

Hi @johhnybest 

Please try this:

First of all, I create a set of sample:

Then create a measure:

both = 
	VAR _Countall = COUNTROWS(ALL('Table'))
	RETURN
		IF(
			COUNTROWS(ALLSELECTED('Table')) = _Countall,
			COUNTROWS(ALLSELECTED('Table'))
		)

Add a slicer and a matrix:

Open the select all in the format of Slicer:

The result is as follow:

^{Best Regards,}

^{Zhengdong Xu}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[johhnybest]

Any help here please that would be greatly appreciated