Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Very basic question (and I apologize for that…)

    Posted Jan 08, 2022 03:24 AM
    Hi All,
    I am very new to Power BI and have difficulties to make what seems to me very basic. I've tried to understand but I must admit I need some help… Here is the situation:

    I have 2 tables, one of a survey with (unique) id and answers and one with the labelled answers


    I first want to count the number of answers group by answers like here

    Then, finally, I would like the result in such a form


    Thanks for your help,
    Emmanuel

    ------------------------------
    Emmanuel Laffort
    ------------------------------


  • 2.  RE: Very basic question (and I apologize for that…)

    Bronze Contributor
    Posted Jan 11, 2022 09:01 AM
    Some sample data would help please.

    ------------------------------
    James Watts
    Business Intelligence Analyst
    ------------------------------



  • 3.  RE: Very basic question (and I apologize for that…)

    Posted Jan 11, 2022 10:12 AM
    Sure James,

    For example, from the table below


    I would like to  get first :


    And then :

    Thanks for your help


    ------------------------------
    Emmanuel
    ------------------------------



  • 4.  RE: Very basic question (and I apologize for that…)

    Bronze Contributor
    Posted Jan 12, 2022 03:24 AM
    Thanks, but can't see/download the data.

    ------------------------------
    James Watts
    Business Intelligence Analyst
    ------------------------------



  • 5.  RE: Very basic question (and I apologize for that…)

    Posted Jan 12, 2022 03:45 AM
      |   view attached
    Ok, see the attached XL file
    One sheet contains the data, the other contains the expected results.
    Thanks,
    Emmanuel

    ------------------------------
    Emmanuel Laffort
    ------------------------------

    Attachment(s)

    xlsx
    BasicExample.xlsx   10 KB 1 version