topic Re: Power BI SharePoint columns - need to roll 11 multi-select field choices/values up into count of IDs in DAX Commands and Tips

Power BI SharePoint columns - need to roll 11 multi-select field choices/values up into count of IDs

Anonymous — Thu, 13 Jun 2024 16:34:48 GMT

Hi all,

I hope this question makes sense:

I have a Power BI dashboard built from a SharePoint list. The SharePoint list has RC1, RC2, RC3, RC4, RC5, RC6 fields/columns. Each of those RC# fields has 11 choices (all the same choices for each of the 6). My goal is to report the distinct # of times the 11 values/choices have been selected per SharePoint ticket/ID# (only counting 1 per ID#, even if it is selected in RC1 and RC3 in the same ticket/ID#).

Right now, this is how I have it set up, but it is only showing the RC1 values right now... I need it to roll all 6 RC field selections into each of the 11 choices/values (shows on the left in the 1st column). Any ideas? Thanks!

Re: Power BI SharePoint columns - need to roll 11 multi-select field choices/values up into count of IDs

amitchandak — Fri, 14 Jun 2024 03:18:21 GMT

Anonymous , Please share the source data sample.

I think you can unpivot all 6 columns and that structure of the table may work well

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Re: Power BI SharePoint columns - need to roll 11 multi-select field choices/values up into count of IDs

Anonymous — Tue, 18 Jun 2024 05:48:01 GMT

HIAnonymous

Can you tell me if your problem is solved? If yes, please accept it as solution.

Best Regards,

Leroy Lu