Forum Discussion

Luca2020's avatar
Luca2020
Helper I
5 years ago
Solved

Summarize problem

Hi,  I've a table with the value of each costumer's order, an order may be divided in additional sub-orders or item according to the type of service required. All items from an order may have the sa...
  • DavisBI's avatar
    DavisBI
    5 years ago

    Hi, Luca2020 ,

     

    I suggest that you provide the model relationship of different tables, one to many or many to one, which is helpful to solve this problem. 

    Nevertheless, I have encountered similar problem before.

    My solution is to create a new calculation column in the many-end table to calculate the number of rows that will be repeated after use RELATED() from one-end table, and then your measure can be divided by the value in this column to get a value that won't be repeated.

    The formula for this calculate column is :

    column = countrows(RELATEDTABLE(<your main table>))

    You can also refer to this article.

     

     Mark this post as solution if this helps, thanks!

DavisBI's avatar
DavisBI
Solution Specialist
5 years ago

Hi, Luca2020 ,

 

I suggest that you provide the model relationship of different tables, one to many or many to one, which is helpful to solve this problem. 

Nevertheless, I have encountered similar problem before.

My solution is to create a new calculation column in the many-end table to calculate the number of rows that will be repeated after use RELATED() from one-end table, and then your measure can be divided by the value in this column to get a value that won't be repeated.

The formula for this calculate column is :

column = countrows(RELATEDTABLE(<your main table>))

You can also refer to this article.

 

 Mark this post as solution if this helps, thanks!