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

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.