power bi visual

[BIswajit_Das]

I have a table like

id  y  z

1  a  a

1  b  a

1  a  a

2  a  a

3  b  b

And i need to create a visual like

for a                                  for b

2/3                                    1/3 

Here 2 is the count of z value and 3 is the count of id means total distinct id

Is there any way to do this??

For Example :

[v-yiruan-msft · Accepted solution]

Hi  @BIswajit_Das ,

It need to make a little adjustment as below for the measure, please find the details in the attachment.

Measure = 
VAR _selvalue =
    SELECTEDVALUE ( 'Z'[z] )
VAR _countx =
    DISTINCTCOUNT ( 'Table'[x] )
VAR _countz =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[x] ),
        FILTER ( 'Table', 'Table'[z] = _selvalue )
    )
RETURN
     _countz&"/"& _countx

Best Regards