Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
samirfarid
Frequent Visitor

How to sum data from SharePoint onto a report

Hi,

 

I currently retrieve some data from a SharePoint list which is stored in a DAX table as follows:

 

IdQuestion 1Question 2Question 3Comments
1YesYesNoLorem Ipsum
2YesNoYesLorem Ipsum dolor sit amet
3(Blank)NoNo 

 

On my Dashboard, I'm want to be able to show a Table / Matrix that shows the amount of Yes, No and blank answered questions. Something like this for example:

 

 YesNoEmpty
Question 1201
Question 2120
Question 3120

 

I read somewhere that this could be achieved using unpivoting in Power Query, but as my list contains about 15 questions and a lot of records, i was wondering whether unpivoting wasnt too much trouble performance wise, or if there is a simpeler way to achieve this.

 

Thanks for the help.

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@samirfarid ,

 

As far as I know, there is no more elegant way.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@samirfarid ,

 

As far as I know, there is no more elegant way.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.