Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count the columns by row

Hi all, 

 

I want to count the columns by row.

The aggregated data is filtered through the slicer in the dashboard.

 

Thanks,

 

 

Need Help

5 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    Please share more details about your scenario so that we could get the solution quickly.

     

    If it is convenient, please share your data sample which could reproduce your scenario and your desired output.

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi team, 

       

      Share the pbix file below and the xlsx file, which is the data source. 

      -  pbix_xlsx_file

       

      First of all, the dashboard is constructed like an attachment and the figures are displayed dynamically by the slicer.

      The dashboard is based on BaseSource, but there are more than 1 million sources of data.
      So I reconstructed the source in the form of ChangeSource.

      Based on ChangeSource, I want to get the same result as BaseSource.

       

      Thanks,

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous,

         

        I'm still a little confused about your requirement.

         

        Do you want to achieve the result like below based on the source of ChangeSource?

         

         

        If it is, you only need to unpivot your column item1, item2, item3 from Change Source in Query Editor.

         

        Then you could create the matrix like this.

         

         

        If I misunderstood your requirement, please share your desired output so that we could help further on it.

         

        Best Regards,

        Cherry