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

[Anonymous]

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!

[Anonymous]

HI@Anonymous

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

Best Regards,

Leroy Lu

[amitchandak]

@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