Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
3 years ago
Solved

power bi visual

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 :

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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