Forum Discussion

HabibAdil's avatar
HabibAdil
Icon for Helper IV rankHelper IV
3 years ago

Groupby or Summarize by Two Columns from Different Tables

Hi, I hope everyone is doing well. Can you please help me with the following: I want to determine supplier monthly performance given the total orders value due for the month is more than certain a...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

I think that you can get the suppliers more than 10k with

Suppliers more than 10k =
VAR PONumbers =
    VALUES ( 'PO Detail'[PO number] )
RETURN
    FILTER (
        VALUES ( 'PO Header'[supplier code] ),
        CALCULATE (
            SUM ( 'PO Header'[order value] ),
            TREATAS ( PONumbers, 'PO Header'[PO number] )
        ) > 10000
    )

You can then store this in a variable and use it as a filter in the % measure.