Forum Discussion
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 :
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&"/"& _countxBest Regards
1 Reply
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&"/"& _countxBest Regards