Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Help with DAX 2

In my Power BI report I have a page for 'sales by employee'.


Management want to select a period of weeks/month and see if any employees have not made any sales in a week (or more).


I have a matrix:

Column A: Tag as 'Pass/Fail'...essentially anyone with a missing week for the period selected is a fail.

Column B: Employee ID

Rows: Month/week 

Value = number of sales


An employee can only be a pass or fail. In other words if they have, for the period selected, 3 weeks of sales but one week without they are a fail.


Simplified example of table in Cube:


My date table has months and weeks


Super User
Super User

@AndyDD_UK Hi! o create a Pass/Fail tag for employees who have missed a week of sales, you can create a measure that checks whether an employee has made a sale in all the selected weeks for the period:


Pass/Fail =
VAR SelectedWeeks = SELECTEDVALUES('Date'[Week])
FILTER('Sales', 'Sales'[Sales] > 0)
COUNTROWS(SalesWeeks) = COUNTROWS(SelectedWeeks),


You can add this measure to your matrix as the first column (Column A) and the Employee ID column as the second column (Column B). For the rows, you can use the week or month column from your date table. Finally, for the values, use the Sales column from your Sales table.

The resulting matrix will show the Pass/Fail tag for each employee in each week/month for the selected period. If an employee missed a week of sales, they will have a Fail tag for that week/month, and if they made a sale in all selected weeks, they will have a Pass tag for the period.





Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors