Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ailteir
Helper I
Helper I

Forms Pro Survey reporting

‎08-07-2019 10:43 PM

Data Structure.pngPivottable.png

 

Using the data structure and resultant pivottable image above I am trying to produce a multiple card visuals that shows the number of projects where a filtered question was answered "no" to by all respondents. For example in the attached pivot if Question02 were "Is there an agreed budget for the project" then there are 2 project where all respondents agree there is no budget.

Message 1 of 9
887 Views
0
8 REPLIES 8
Mariusz
Community Champion
Community Champion

‎08-08-2019 12:34 AM

Hi @Ailteir 

 

Can you provide the data sample you base your pivot on?

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

Message 2 of 9
871 Views
0
Ailteir
Helper I
Helper I
In response to Mariusz

‎08-08-2019 12:38 AM

Can do but not quite sure how I do it through the forum?

Message 3 of 9
869 Views
0
Ailteir
Helper I
Helper I
In response to Ailteir

‎08-08-2019 03:29 AM

All data is fictitious;
Team Member,Project,Question,Answer,AnswerValue
Elizabeth Barnes,Project01,Question01,Yes,1
Elizabeth Barnes,Project01,Question02,No,0
Elizabeth Barnes,Project01,Question03,Yes,1
Elizabeth Barnes,Project01,Question04,Yes,1
Elizabeth Barnes,Project01,Question05,No,0
Elizabeth Barnes,Project01,Question06,Yes,1
Elizabeth Barnes,Project01,Question07,Yes,1
Elizabeth Barnes,Project01,Question08,No,0
Elizabeth Barnes,Project01,Question09,Yes,1
Elizabeth Barnes,Project01,Question10,No,0
Elizabeth Barnes,Project02,Question01,No,0
Elizabeth Barnes,Project02,Question02,Yes,1
Elizabeth Barnes,Project02,Question03,No,0
Elizabeth Barnes,Project02,Question04,No,0
Elizabeth Barnes,Project02,Question05,Yes,1
Elizabeth Barnes,Project02,Question06,No,0
Elizabeth Barnes,Project02,Question07,No,0
Elizabeth Barnes,Project02,Question08,Yes,1
Elizabeth Barnes,Project02,Question09,No,0
Elizabeth Barnes,Project02,Question10,No,0
Elizabeth Barnes,Project03,Question01,Yes,1
Elizabeth Barnes,Project03,Question02,No,0
Elizabeth Barnes,Project03,Question03,Yes,1
Elizabeth Barnes,Project03,Question04,No,0
Elizabeth Barnes,Project03,Question05,Yes,1
Elizabeth Barnes,Project03,Question06,Yes,1
Elizabeth Barnes,Project03,Question07,Yes,1
Elizabeth Barnes,Project03,Question08,Yes,1
Elizabeth Barnes,Project03,Question09,No,0
Elizabeth Barnes,Project03,Question10,Yes,1
Elizabeth Barnes,Project04,Question01,No,0
Elizabeth Barnes,Project04,Question02,No,0
Elizabeth Barnes,Project04,Question03,No,0
Elizabeth Barnes,Project04,Question04,Yes,1
Elizabeth Barnes,Project04,Question05,No,0
Elizabeth Barnes,Project04,Question06,No,0
Elizabeth Barnes,Project04,Question07,No,0
Elizabeth Barnes,Project04,Question08,No,0
Elizabeth Barnes,Project04,Question09,No,0
Elizabeth Barnes,Project04,Question10,No,0
Elizabeth Barnes,Project05,Question01,No,0
Elizabeth Barnes,Project05,Question02,Yes,1
Elizabeth Barnes,Project05,Question03,Yes,1
Elizabeth Barnes,Project05,Question04,Yes,1
Elizabeth Barnes,Project05,Question05,No,0
Elizabeth Barnes,Project05,Question06,Yes,1
Elizabeth Barnes,Project05,Question07,No,0
Elizabeth Barnes,Project05,Question08,Yes,1
Elizabeth Barnes,Project05,Question09,No,0
Elizabeth Barnes,Project05,Question10,No,0
Katelyn West,Project01,Question01,Yes,1
Katelyn West,Project01,Question02,No,0
Katelyn West,Project01,Question03,No,0
Katelyn West,Project01,Question04,No,0
Katelyn West,Project01,Question05,Yes,1
Katelyn West,Project01,Question06,Yes,1
Katelyn West,Project01,Question07,No,0
Katelyn West,Project01,Question08,Yes,1
Katelyn West,Project01,Question09,Yes,1
Katelyn West,Project01,Question10,Yes,1
Katelyn West,Project02,Question01,No,0
Katelyn West,Project02,Question02,No,0
Katelyn West,Project02,Question03,No,0
Katelyn West,Project02,Question04,No,0
Katelyn West,Project02,Question05,No,0
Katelyn West,Project02,Question06,Yes,1
Katelyn West,Project02,Question07,No,0
Katelyn West,Project02,Question08,Yes,1
Katelyn West,Project02,Question09,Yes,1
Katelyn West,Project02,Question10,Yes,1
Katelyn West,Project03,Question01,Yes,1
Katelyn West,Project03,Question02,No,0
Katelyn West,Project03,Question03,Yes,1
Katelyn West,Project03,Question04,No,0
Katelyn West,Project03,Question05,Yes,1
Katelyn West,Project03,Question06,No,0
Katelyn West,Project03,Question07,Yes,1
Katelyn West,Project03,Question08,Yes,1
Katelyn West,Project03,Question09,No,0
Katelyn West,Project03,Question10,No,0
Katelyn West,Project04,Question01,No,0
Katelyn West,Project04,Question02,No,0
Katelyn West,Project04,Question03,No,0
Katelyn West,Project04,Question04,No,0
Katelyn West,Project04,Question05,No,0
Katelyn West,Project04,Question06,No,0
Katelyn West,Project04,Question07,No,0
Katelyn West,Project04,Question08,Yes,1
Katelyn West,Project04,Question09,No,0
Katelyn West,Project04,Question10,Yes,1
Katelyn West,Project05,Question01,Yes,1
Katelyn West,Project05,Question02,No,0
Katelyn West,Project05,Question03,Yes,1
Katelyn West,Project05,Question04,No,0
Katelyn West,Project05,Question05,No,0
Katelyn West,Project05,Question06,Yes,1
Katelyn West,Project05,Question07,Yes,1
Katelyn West,Project05,Question08,No,0
Katelyn West,Project05,Question09,No,0
Katelyn West,Project05,Question10,No,0
Eliana Garcia,Project01,Question01,Yes,1
Eliana Garcia,Project01,Question02,No,0
Eliana Garcia,Project01,Question03,Yes,1
Eliana Garcia,Project01,Question04,Yes,1
Eliana Garcia,Project01,Question05,No,0
Eliana Garcia,Project01,Question06,No,0
Eliana Garcia,Project01,Question07,Yes,1
Eliana Garcia,Project01,Question08,No,0
Eliana Garcia,Project01,Question09,No,0
Eliana Garcia,Project01,Question10,Yes,1
Eliana Garcia,Project02,Question01,Yes,1
Eliana Garcia,Project02,Question02,No,0
Eliana Garcia,Project02,Question03,No,0
Eliana Garcia,Project02,Question04,Yes,1
Eliana Garcia,Project02,Question05,Yes,1
Eliana Garcia,Project02,Question06,Yes,1
Eliana Garcia,Project02,Question07,No,0
Eliana Garcia,Project02,Question08,Yes,1
Eliana Garcia,Project02,Question09,Yes,1
Eliana Garcia,Project02,Question10,Yes,1
Eliana Garcia,Project03,Question01,Yes,1
Eliana Garcia,Project03,Question02,No,0
Eliana Garcia,Project03,Question03,No,0
Eliana Garcia,Project03,Question04,No,0
Eliana Garcia,Project03,Question05,Yes,1
Eliana Garcia,Project03,Question06,Yes,1
Eliana Garcia,Project03,Question07,No,0
Eliana Garcia,Project03,Question08,Yes,1
Eliana Garcia,Project03,Question09,Yes,1
Eliana Garcia,Project03,Question10,No,0
Eliana Garcia,Project04,Question01,Yes,1
Eliana Garcia,Project04,Question02,Yes,1
Eliana Garcia,Project04,Question03,No,0
Eliana Garcia,Project04,Question04,Yes,1
Eliana Garcia,Project04,Question05,No,0
Eliana Garcia,Project04,Question06,Yes,1
Eliana Garcia,Project04,Question07,No,0
Eliana Garcia,Project04,Question08,Yes,1
Eliana Garcia,Project04,Question09,Yes,1
Eliana Garcia,Project04,Question10,Yes,1
Eliana Garcia,Project05,Question01,No,0
Eliana Garcia,Project05,Question02,Yes,1
Eliana Garcia,Project05,Question03,No,0
Eliana Garcia,Project05,Question04,No,0
Eliana Garcia,Project05,Question05,No,0
Eliana Garcia,Project05,Question06,Yes,1
Eliana Garcia,Project05,Question07,No,0
Eliana Garcia,Project05,Question08,Yes,1
Eliana Garcia,Project05,Question09,No,0
Eliana Garcia,Project05,Question10,No,0
McKenzie Evans,Project01,Question01,No,0
McKenzie Evans,Project01,Question02,No,0
McKenzie Evans,Project01,Question03,No,0
McKenzie Evans,Project01,Question04,Yes,1
McKenzie Evans,Project01,Question05,No,0
McKenzie Evans,Project01,Question06,Yes,1
McKenzie Evans,Project01,Question07,No,0
McKenzie Evans,Project01,Question08,Yes,1
McKenzie Evans,Project01,Question09,No,0
McKenzie Evans,Project01,Question10,No,0
McKenzie Evans,Project02,Question01,Yes,1
McKenzie Evans,Project02,Question02,Yes,1
McKenzie Evans,Project02,Question03,No,0
McKenzie Evans,Project02,Question04,Yes,1
McKenzie Evans,Project02,Question05,No,0
McKenzie Evans,Project02,Question06,Yes,1
McKenzie Evans,Project02,Question07,Yes,1
McKenzie Evans,Project02,Question08,No,0
McKenzie Evans,Project02,Question09,Yes,1
McKenzie Evans,Project02,Question10,No,0
McKenzie Evans,Project03,Question01,No,0
McKenzie Evans,Project03,Question02,No,0
McKenzie Evans,Project03,Question03,Yes,1
McKenzie Evans,Project03,Question04,No,0
McKenzie Evans,Project03,Question05,No,0
McKenzie Evans,Project03,Question06,Yes,1
McKenzie Evans,Project03,Question07,No,0
McKenzie Evans,Project03,Question08,Yes,1
McKenzie Evans,Project03,Question09,No,0
McKenzie Evans,Project03,Question10,Yes,1
McKenzie Evans,Project04,Question01,Yes,1
McKenzie Evans,Project04,Question02,No,0
McKenzie Evans,Project04,Question03,Yes,1
McKenzie Evans,Project04,Question04,No,0
McKenzie Evans,Project04,Question05,No,0
McKenzie Evans,Project04,Question06,No,0
McKenzie Evans,Project04,Question07,Yes,1
McKenzie Evans,Project04,Question08,Yes,1
McKenzie Evans,Project04,Question09,Yes,1
McKenzie Evans,Project04,Question10,No,0
McKenzie Evans,Project05,Question01,Yes,1
McKenzie Evans,Project05,Question02,No,0
McKenzie Evans,Project05,Question03,No,0
McKenzie Evans,Project05,Question04,No,0
McKenzie Evans,Project05,Question05,Yes,1
McKenzie Evans,Project05,Question06,Yes,1
McKenzie Evans,Project05,Question07,No,0
McKenzie Evans,Project05,Question08,Yes,1
McKenzie Evans,Project05,Question09,Yes,1
McKenzie Evans,Project05,Question10,Yes,1
Blair Silva,Project01,Question01,Yes,1
Blair Silva,Project01,Question02,No,0
Blair Silva,Project01,Question03,No,0
Blair Silva,Project01,Question04,Yes,1
Blair Silva,Project01,Question05,Yes,1
Blair Silva,Project01,Question06,No,0
Blair Silva,Project01,Question07,No,0
Blair Silva,Project01,Question08,No,0
Blair Silva,Project01,Question09,Yes,1
Blair Silva,Project01,Question10,No,0
Blair Silva,Project02,Question01,Yes,1
Blair Silva,Project02,Question02,Yes,1
Blair Silva,Project02,Question03,No,0
Blair Silva,Project02,Question04,Yes,1
Blair Silva,Project02,Question05,No,0
Blair Silva,Project02,Question06,Yes,1
Blair Silva,Project02,Question07,No,0
Blair Silva,Project02,Question08,No,0
Blair Silva,Project02,Question09,Yes,1
Blair Silva,Project02,Question10,Yes,1
Blair Silva,Project03,Question01,Yes,1
Blair Silva,Project03,Question02,No,0
Blair Silva,Project03,Question03,No,0
Blair Silva,Project03,Question04,No,0
Blair Silva,Project03,Question05,No,0
Blair Silva,Project03,Question06,No,0
Blair Silva,Project03,Question07,Yes,1
Blair Silva,Project03,Question08,Yes,1
Blair Silva,Project03,Question09,No,0
Blair Silva,Project03,Question10,Yes,1
Blair Silva,Project04,Question01,Yes,1
Blair Silva,Project04,Question02,No,0
Blair Silva,Project04,Question03,Yes,1
Blair Silva,Project04,Question04,No,0
Blair Silva,Project04,Question05,Yes,1
Blair Silva,Project04,Question06,Yes,1
Blair Silva,Project04,Question07,No,0
Blair Silva,Project04,Question08,No,0
Blair Silva,Project04,Question09,No,0
Blair Silva,Project04,Question10,Yes,1
Blair Silva,Project05,Question01,Yes,1
Blair Silva,Project05,Question02,Yes,1
Blair Silva,Project05,Question03,Yes,1
Blair Silva,Project05,Question04,Yes,1
Blair Silva,Project05,Question05,No,0
Blair Silva,Project05,Question06,No,0
Blair Silva,Project05,Question07,Yes,1
Blair Silva,Project05,Question08,Yes,1
Blair Silva,Project05,Question09,Yes,1
Blair Silva,Project05,Question10,Yes,1

 

Message 4 of 9
865 Views
0
Mariusz
Community Champion
Community Champion
In response to Ailteir

‎08-08-2019 06:21 AM

Hi @Ailteir 

Count rows = 
VAR _no = CALCULATE( COUNTROWS( 'Table' ),  'Table'[Answer] = "No" ) 
VAR _all = CALCULATE( COUNTROWS( 'Table' ),  ALL( 'Table'[Answer] ) )
RETURN IF( _no = _all, _all )

Please see the below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Message 5 of 9
851 Views
0
Ailteir
Helper I
Helper I
In response to Mariusz

‎08-08-2019 07:24 AM

Mariusz,

 

Seems good. Late in the morning here - 2am. I will confirm it a solution tomorrow.

 

Regards

Message 6 of 9
846 Views
0
Ailteir
Helper I
Helper I
In response to Ailteir

‎08-08-2019 07:53 PM

Mariusz,

Thx have mocked it up. Nearly there it produces this using standard table visual.

I would like to show as seperately as per second graphic. For example from the extract in the table the card graphic I propose would record 2 projects having all respondents answering "No" to  Question02.

 

Regards

Table visualTable visualDesired card based visualDesired card based visual

Message 7 of 9
835 Views
0
Mariusz
Community Champion
Community Champion
In response to Ailteir

‎08-09-2019 12:20 AM

Hi @Ailteir 

 

Do you need something like below?

 

image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Message 8 of 9
828 Views
0
Ailteir
Helper I
Helper I
In response to Mariusz

‎08-13-2019 03:12 AM

Mariusz,

 

Apologies I took an alternative using a query.

 

Reagrds

Message 9 of 9
765 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

View All
Top Solution Authors
View All