Forum Discussion
Complex Dax use case
I have this complex use case, I need to get a list of projects or flag them in DAX based on the following: - If a project has multiple expense types then flag : The project that ha...
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.