Power Pivot - COUNT IF

[joslaz]

Hey together,

I am just aiming a pretty simple problem.
I have the following table:

[TABLE="width: 313"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]DOC[/TD]
[TD]UNIT[/TD]
[TD]DATE[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD="align: right"]40017280[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]40017281[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]40017282[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]40017283[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]40017284[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]40017285[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]40017286[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]40017287[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]40017299[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD="align: right"]40017300[/TD]
[TD]A[/TD]
[TD="align: right"]02.05.19 00:00[/TD]
[TD="align: right"]13[/TD]
[/TR]
</tbody>[/TABLE]

I have loaded this table in Power Pivot, which I load as a Pivot table.

I want to count how many DOCs (Distinct) where created in the chosen week with a status above 10.
THe chosen week is a paramter in a cell. For example Cell A2=22

How can I adapt this with a measure?

Doas anyone have andy idea?


Best Regards

 

[citizenbh]

Solution to Excrel PowerPivot:
Create tWeekNo and Calendar tables

Measures:

mWeekNo: = AVERAGE ([WeekNo]) i
mCountDoc: = CALCULATE (DISTINCTCOUNT ([DOC]), FILTER (Table1, [Status]> = 10), FILTER (Table1, [Week Number] = tWeekNo [mWeekNo]))

After changing the WeekNo Refresh table

Link for example:

https://www.dropbox.com/s/2kddwaqayao3l93/DistinctCountConditionWeek_DAX.xlsx?dl=0

 

[joslaz]

work perfect!
thanks

 

[citizenbh]

Cheers!