Filter Multiple Columns from single table

Question

I have a table RT Hr DB an it has multiple columns. Want to filter column Department=UW and Hour Type=Overtime and sum the Days. This is what I have so far

SUMX(FILTER(FILTER('RT Hr DB','RT Hr DB'[Hour Type]="Vacation"), RT Hr DB'[Department]="Underwriting"), 'RT Hr DB[Days])

jdbuchanan71 · Answer

Hello&nbsp;Anonymous&nbsp;Give this a try.UW OT = 
CALCULATE(
    SUM ( 'RT Hr DB'[Days] ),
    'RT Hr DB'[Department] = "Underwriting",
    'RT Hr DB'[Hour Type] = "Overtime")

anonymous · Answer

jdbuchanan71&nbsp;&nbsp;I tried this but it still does not give me the right answer.

jdbuchanan71 · Answer

Hello&nbsp;Anonymous&nbsp;Please provide some sample data and and example of the expected outcome.

anonymous · Answer

jdbuchanan71&nbsp;Formula 1 = (SUMX(filter('RT Prod HC',[Team]="UW"),[Workdays])-(CALCULATE(SUM('RT Hr DB'[Days]),'RT Hr DB'[Hour Type] = "Vacation",'RT Hr DB'[Department] = "Underwriting"))-CALCULATE(SUM('RT Hr DB'[Days]),'RT Hr DB'[Hour Type] = "Partial Hours Off",'RT Hr DB'[Department] = "Underwriting")+(CALCULATE(SUM('RT Hr DB'[Days]),'RT Hr DB'[Hour Type] = "Overtime",'RT Hr DB'[Department] = "Underwriting"))/(SUMX(FILTER('RT Prod HC',[Team]="UW"),'RT Prod HC'[Prod HC])))&nbsp;Formula 2 =&nbsp;(SUMX(filter('RT Prod HC',[Team]="UW"),[Workdays])-((SUM('UW Vacation'[Days]))/(SUMX(FILTER('RT Prod HC',[Team]="UW"),'RT Prod HC'[Prod HC])))+((SUM('UW Overtime1'[Days]))/(SUMX(FILTER('RT Prod HC',[Team]="UW"),'RT Prod HC'[Prod HC]))))&nbsp;Formula 1 is when I tried to filter the same table multiple times. Formula 2 is when I duplicate the table in power query and then put in the filters. Both have the same data but they are giving me 2 different answers.

jdbuchanan71 · Answer

Anonymous&nbsp;In your picture, what number is wrong and what should it be?&nbsp; Also, we will need sample data from the tables involved and to know how the model relationships are set up.&nbsp; If you can share your .pbix file that will help us answer your question.

Forum Discussion

Filter Multiple Columns from single table

6 Replies

Related content

odata Report Level Filters Multiple Filters Same Column

filtering on multiple columns

Single Slicer to Filter Multiple Columns

Multiple Column Filter

Slicer for filtering several columns