Dynamic Legend Based upon Slicer- Error Counting

[bcobrien1977]

Hi,

I have a visual where I want the user to select either the Requesting Side or Receiving Side and then be able to get a count of the items. 

I have a table that has all of the exhaustive list of requesting and receiving VS/SS and basically I want the chart to update with what I select and have the correct count.

My problem is that the below measure is saying that it can't convert the VS/SS A to be a true false and I am getting an error on the count. 

Attribute	VS/SS
Requesting Side	A
Requesting Side	A
Requesting Side	A
Requesting Side	A
Requesting Side	A
Receiving Side	B
Receiving Side	B
Receiving Side	B
Receiving Side	B
Receiving Side	B

I created a measure 

Unique Counts =

VAR SelectedType =

    SELECTEDVALUE('Axis Table'[Attribute])

VAR Selected_Value =

    VALUES ('Axis Table'[Value Stream/Shared Service])

RETURN

    SWITCH (

        SelectedType ,

        "Receiving Side", CALCULATE ( DISTINCTCOUNT(vwJiraDependencies_UAT[IssueKey] ), 'RECEIVING SIDE'[Receiving Side] IN Selected_Value),

        CALCULATE ( DISTINCTCOUNT(vwJiraDependencies_UAT[IssueKey] ), 'REQUESTIING SIDE'[Requesting Side]

Any insight on how to do this would be greatly appreciated. The Attribute table and the main table are connected. 

Thanks

[bcobrien1977]

Can you attach your file?  There is something that I am missing.

[ghoshabhijeet]

@bcobrien1977 Sure! Please find attached.

[ghoshabhijeet]

@bcobrien1977  Thanks for providing the sample data.

Here is my solution:

Steps:

1. Unpivot the main data table for the Receiving and Requesting column. The table should look like this after Unpivot:

2. Create the relationship between the two tables. The data model should look like this.

3.  Create a measure for Unique Count:

Unique Count =
CALCULATE (
COUNT ( 'Issue Table'[Value] ),
'Issue Table'[Value] = SELECTEDVALUE ( 'Issue Table'[Value] )
)

4. Create a slicer and chart in the Report. The visual should look like this:

Hope this helps.

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍

[bcobrien1977]

Thanks.  I am assuming that your attribute table literally has two rows, 1 receiving and 1 requesting? Otherwise you have a many to many relationship.

[ghoshabhijeet]

@bcobrien1977  Thanks for your query. Can you please provide some dummy data of your main table. Would be easier to build the calculation. Thanks !

[bcobrien1977 · Accepted solution]

Issue	Requesting	Receiving
1	A	B
2	A	B
3	C	A
4	D	A
5	C	D
6	B	C
7	D	A
8	B	C
9	D	A

Basically I want to be able to filter on either receiving or requesting side  and show the Attrbiute

Example show me receiving and pick Attribute A and get the copy of B, C, D, etc.   I am getting an error that the text can't be converted to true/false.  If you don't mind sharing the PBIX file, that would be great.

Thanks!