Forum Discussion
Complex Dax use case
what are you struggling specifically, bringing all the requirements together? also can you provide the data in text format not a screenshot.
The part I am strugging with is when the project has 2 or more expense categories with 5%, I am able to get a result if it's just one expense category bigger than 5%:
Project | Date | Expense Type | Variance in $ | Variance in % |
ABC | 4/3/2023 | X | 93000 | 6% |
ABC | 3/3/2023 | Y | 70000 | 10% |
ABC | 4/3/2023 | Y | 5000 | 1% |
KLM | 2/3/2023 | Z | 12000 | 2% |
MNO | 4/3/2023 | X | 6500 | 7% |
EFG | 2/3/2023 | Z | 50000 | 10% |
EFG | 4/3/2023 | M | 60000 | 12% |
EFG | 3/3/2023 | Y | 1000 | 3% |
as i am going through this i am little confused about your conditions;
for multiple rows must all expenses associated to that project be >= 5% or just >5% and < 85000 or <=85000
for a single row is it > 5% and < 85000?
I am trying to under why these 2 rows dont qualify for flagging.
Not all rows, if 2 or more rows associated with that project have more than 5% and those same rows are under 85000. Because Project ABC have a row that has over 5% ( first row 6%) and 93000 it shouldn't show up on the list.