Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Return True when all values are equal to True, otherwise return false

Hi Team,   I have been working on a report which shows the status of timesheet approvals via departments and employees. This is the current report look and feel   Overall, I am using a cur...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey mate, using your Measure, it looks to be working when department has a single Employee.

This is from lastweeks, so every field should be true due approval has to happen before payroll. 

 

I have a feeling its something to do with the ROW contexting BI does, but this is now into realm beyond my technical knowledge of BI 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yeah, everything you're describing seems to be the expected behavior, so I'm not really understanding what you're hoping to see differently in your use case.

I would recommend doing some reading/watching on the concept of "filter context" within Power BI. Here's one (of many) good resources on the topic.
DAX for Power BI - Understanding Filter Context 


  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Eberry, I think I have isolated what is causing the incorrect data I am seeing.

    I believe, what is happening, because I am displaying a Matrix of Columns of dates. When an Employee hasn't worked that day, they automatically being displayed and returning a false. 

     

    I believe, I need to write a Filter on Names, which would only return people who worked during that payweek. 

     

    Looking at the filter command, I can't see how i can filter via date. Any advice? 

     

    I was thinking something like,

    AuthorisedCompleted = IF(SELECTEDVALUE('dim Dates'[DateOnly]) = SELECTEDVALUE(TimeSheet[DTAEnd].[Date]),
    IF(SELECTEDVALUE('TimeSheet'[Authorised]) = TRUE(), "Ok", "Unauthorised"),
    "Did Not Work").