Forum Discussion
Filter Multiple Columns from single table
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 D...
Anonymous
In your picture, what number is wrong and what should it be? Also, we will need sample data from the tables involved and to know how the model relationships are set up. If you can share your .pbix file that will help us answer your question.
This table is where the raw data is taken from. I duplicated this table to filter out without a formula. The line graph with value 8.95 should be the right one which i got by duplicating the table and filtering it separately rather than doing multiple filters with the formula.