Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

data aggregation

Good morning, I have a question for you. Why power bi when I have a field with which I want to add and have the total at the bottom aggregate the rows that are equal to me? Is there the possibility...
  • v-zhenbw-msft's avatar
    5 years ago

    Hello @tarz ,

    Don't want to summarize and display Total?

    If yes, we may use both ways to meet your requirements.

    1. Add an index column and place the index column in the visual table configure not to summarize it.

    data1.jpg

    2. The second way is to create two table visuals. One summarizes, another does not summarize. And put the table does not summarize on the top layer.

    data2.jpg

    data3.jpg

    If you have any questions, please ask here and we will try to resolve it.

    Best regards

    Community support team _ zhenbw

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

    BTW, pbix as an attachment.