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
HabibAdil's avatar
HabibAdil
Icon for Helper IV rankHelper IV
3 years ago

johnt75 Many thanks for your respone. Forgive my ignorence, but how does this account for the time period of each month. I want to display the results for each month. If I select a date of range of 01/01/2022 to 01/07/2022, for each month and supplier if total value due was not more than 10k, the PO lines for those suppliers should not be included in the calculation. Regards

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

The code uses the relationship from calendar to the order detail table. By placing fields from your calendar table into the visual the filter will pass from the calendar table to order table, and so 

VALUES ( 'PO Detail'[PO number] )

will only return the rows which happened in the given time period. By using these values as a filter on the order header table only those orders will be considered

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

    johnt75 Thanks for that. It works on visuals, but I need to use in another measure and calculated columns using the filter function with calculate.