Forum Discussion

Ailteir's avatar
Ailteir
Icon for Helper I rankHelper I
7 years ago

Forms Pro Survey reporting

  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"...
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

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

 

Ailteir's avatar
Ailteir
Icon for Helper I rankHelper I
7 years ago

Mariusz,

 

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

 

Regards

  • Ailteir's avatar
    Ailteir
    Icon for Helper I rankHelper I
    7 years ago

    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 visualDesired card based visual

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi Ailteir 

       

      Do you need something like 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

       

      • Ailteir's avatar
        Ailteir
        Icon for Helper I rankHelper I
        7 years ago

        Mariusz,

         

        Apologies I took an alternative using a query.

         

        Reagrds