Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum up values in column

The following is a part of the modell which my report is based on( all relations are 1:*). There is no connection between fact1 and fact2 tables and in report there are two slicers read data f...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks v-xulin-mstf for your reply. The issue is resolved by changing the tabular model and measure. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I tested the code but it seems that it doesn't work when I select values from slicer. I changed the measure to :

 

Length :=
calculate(
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'Fact2', 'Fact2'[OrderKey] ),
        "sum of length", CALCULATE ( MAX ( 'Fact2'[length] ) )
    ),
    [sum of length]
)
, FILTER (
        'Fact2',
        'Fact2'[OrderKey] IN VALUES ( 'Fact1'[OrderKey])
           )
)

 

 

But it doesn't show the correct value. It sums up all orderkeys without any concern to selection in slicer.

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

I am not sure how your model and the relationships are defined, you may share a sample PBIX file to check what sort of issues you are facing.



Also, explain the out put you are trying to achieve.