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

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").