Visualize the intersect in a Venn Diagram or pie chart

[Anonymous]

Hi experts,

I'm struggling trying to visualize this data:

IdUser	IdVideo	IdDevice	Category	Live	NoLive	Date
Us1	Vid1	Dev1	Live	1	0	03/04/2019
Us1	Vid1	Dev2	Live	1	0	03/04/2019
Us1	Vid2	Dev1	NoLive	0	1	03/06/2019
Us1	Vid3	Dev1	Live	1	0	05/04/2019
Us2	Vid1	Dev1	Live	1	0	03/04/2019
Us2	Vid4	Dev2	NoLive	0	1	01/04/2019
Us3	Vid5	Dev1	NoLive	0	1	15/05/2019
Us4	Vid2	Dev1	NoLive	0	1	09/07/2019
Us5	Vid3	Dev1	Live	1	0	05/04/2019
Us6	Vid5	Dev2	Live	1	0	25/09/2019

What I'm trying to do is to visualize this data in a venn diagram. For example, if I select dates from 03/04/2019 to 03/06/2019, It should be:

Live; Both; NoLive

Us5; Us1; Us3

        Us2

I have created a column as follows:

Both =
// Var _Live = CALCULATETABLE('Table';FILTER('Table';'Table'[Live]=1))
// Var _NoLive = CALCULATETABLE('Table';FILTER('Table';'Table'[NoLive]=1))
Var _User = 'Table'[IdUser]
Var _NoLive = 'Table'[NoLive]
Return
IF( CALCULATE(
COUNTROWS('Table');
FILTER('Table'; 'Table'[Live]=_NoLive && 'Table'[IdUser]=_User)
); 1; 0
)

And then I've created a measure:

Measure = DISTINCTCOUNT('Table'[IdUser])

However, I'm not getting the desire output. Please refer to my PBIX FIle

What I'm missing? Also I would like to know if it's possible to draw a Venn diagram that can be filtered by any other dimensions?

Thanks for your help.

[v-chuncz-msft · Accepted solution]

@Anonymous 

Check the sample report and take a look at this post.