Count Measure with Filter

[545]

i have this measure:

# Total_Eng_reports_By_date =

VAR x = CALCULATE(DISTINCTCOUNT(qryAssemblyProcessReport[ItemID]), tblStations[StationCode]=28)

return IF(ISBLANK(x), 0,x)

the date is set to 4/3/2024 

it checks if the item is in station 28, and if it is so then it counts it as 1.

 it counted 5.

but there are 16 in power query 

AssemblyDocNo             ItemID                   itemclass        OrderID                stationcode           employeecode       process date   

[Anonymous · Accepted solution]

Hi @545,

Perhaps You can add variable table with summarize function to calculate the measure formula on the detail level. Then you can summary it's result based on iterator aggregation functions.

Measure Totals, The Final Word - Microsoft Fabric Community

Regards,

Xiaoxin Sheng

[_AAndrade]

Hi @545,

Can you provide a sample pbix file with same data so I can take a look?

[545]

is there a quick way to do that?