Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Visualize the intersect in a Venn Diagram or pie chart

Hi experts,

 

I'm struggling trying to visualize this data:

 

IdUserIdVideoIdDeviceCategoryLiveNoLiveDate
Us1Vid1Dev1Live1003/04/2019
Us1Vid1Dev2Live1003/04/2019
Us1Vid2Dev1NoLive0103/06/2019
Us1Vid3Dev1Live1005/04/2019
Us2Vid1Dev1Live1003/04/2019
Us2Vid4Dev2NoLive0101/04/2019
Us3Vid5Dev1NoLive0115/05/2019
Us4Vid2Dev1NoLive0109/07/2019
Us5Vid3Dev1Live1005/04/2019
Us6Vid5Dev2Live1025/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.
General Comment
Need Help