Matrix Countrows

Anonymous — Fri, 05 May 2023 06:44:31 GMT

Hi all,

I am stuck with a measure creation and would really appreciate some help!

I have a tabular model with a lot of measures and need to create another one working with existing ones.

This is related to timesheets.

I have a measure [Total Hours] - hours logged by employee

measure [Standard Hours] - hours expected for the employee.

The new measure needs to check if total hours<standard hours * .75 and flag 1 if true. And count the true total.

I created a measure that works in a table, but when I use in a matrix with other rows the total is not counting correctly.

I've tested many ways and this is what I have at the moment(i just added the if because i just received a requirement to also return 1 if total hours =0):

var filter1 = COUNTROWS(FILTER (
'Staff Detail',
('Staff Detail'[Left Date] > TODAY() - 7 || ISBLANK('Staff Detail'[Left Date])) // check if employee is still valid for this week timesheet
&& [Total Hours]<Measures_[Standard Hours]*.75 ))

return

if([Total Hours]=0,1,filter1)

The matrix has 4 rows( service line- office - name - client name - description

the flag is working fine, just need to count the totals. I tried countx to change context but didn't work.

Thanks,

Re: Matrix Countrows

Mahesh0016 — Fri, 05 May 2023 11:46:08 GMT

Anonymous Please Share your Expected Output.

Re: Matrix Countrows

Anonymous — Fri, 05 May 2023 14:23:26 GMT

Hi Mahesh0016, I'd like to see the count for the total rows flagged with 1 on the matrix total.

topic Re: Matrix Countrows in DAX Commands and Tips

Matrix Countrows

Re: Matrix Countrows

Re: Matrix Countrows