Forum Discussion

MIkkelHyldig's avatar
MIkkelHyldig
Helper II
4 years ago
Solved

Dynamically return single value by columns

Hi,  The end result should be: Item no 32 = 3000 quantity and not 9000 when I sum on Item No.  The issue is that my table duplicates the quantity by the "Details" as quantity only relates to Do...
Need Help
  • MIkkelHyldig's avatar
    MIkkelHyldig
    4 years ago

    Hi all, 
    I created a new table with unique item No to return a single value (e.g. 3000) and not sum by Details. 

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, MIkkelHyldig 

 

Try to create a measure like this:

Measure = 
CALCULATE(
    // MIN('Table'[Quantity]),
    // MAX('Table'[Quantity]),
    AVERAGE('Table'[Quantity]),
    FILTER(ALLSELECTED('Table'),'Table'[Doc No]=MAX('Table'[Doc No])&&'Table'[Item No]=MAX('Table'[Item No]))
    )

 

Result:

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MIkkelHyldig's avatar
MIkkelHyldig
Helper II
4 years ago

Hi and thanks for the reply. I found a solution by creating a new table with unique item no. Havent tried your solution