Search code examples
powerbipowerbi-desktop

All rows and total of the rows showing same values in power BI

I am trying to show "Some Column Name" against "Total Amount" in Power BI.

I am expecting the following results:

enter image description here

But instead it's showing me the following results:

enter image description here

The current data type is "fixed decimal number" I tried changing it to "Decimal number" or "Whole Number" but it did not work.

Any suggestions?

Solution

  • The reason why you have a single repeating value is because you did not create a relationship in powerbi model. If for example you have two tables Sales and Staff and you want to sum all staffs sales.

    enter image description here

    if no relationship created between table in power BI

    enter image description here

    The output will look like this

    enter image description here

    However when a relationship is created between the tables enter image description here

    The output will be correct

    enter image description here