Forum Discussion
Count the relationships
maybe you can try this in PQ.
1. sort the benefit plan name column
2. create a new column to combine benefit name and priority column
=[Benefit Name] & " "&[Benefit Plan Priority]
3. group by
= Table.Group(#"Added Custom", {"patient name"}, {{"Benefit", each Text.Combine([Custom],","), type text}})
at last, you can use distinctcount or remove duplicates to get the benefit combination amount.
pls see the attachment below
bwhiteaccess
Can you provide sample data and expected output?
Regards,
NG
We have about 250 different benefit plans. Some patients have multiple plans, some being primary and others being secondary.
What I need to know is what combonations we have and how many there are.
Example - Joe S. has United Healthcare primary and Medicaid secondary.
Thanks
Thank you.
maybe you can try this in PQ.
1. sort the benefit plan name column
2. create a new column to combine benefit name and priority column
=[Benefit Name] & " "&[Benefit Plan Priority]
3. group by
= Table.Group(#"Added Custom", {"patient name"}, {{"Benefit", each Text.Combine([Custom],","), type text}})
at last, you can use distinctcount or remove duplicates to get the benefit combination amount.
pls see the attachment below
Hello bwhiteaccess , and thank you for sharing a question with the Community. This reply is informational. Please follow the decorum of the Community Forum when asking a question.
Please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Proud to be a Super User!
