Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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!
Can you attach your file? There is something that I am missing.
@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 👍 |
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.
@bcobrien1977 Thanks for your query. Can you please provide some dummy data of your main table. Would be easier to build the calculation. Thanks !
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |