calculate the count and measure as filter

[po]

Hi,

Have a table with following columns

Yrwk Region Shop Day Supplied Credited

We then have a measure whereby we calculate % sold and have a flag to indicate if missed target (i.e. % sold less than target)

iF ('%sold < MIN(target),1,0)

Wish now to count the number of shops in a region in a week where have failed but if try and craete maesure as

sum(iF ('%sold < MIN(target),1,0)) doesn't allow this.

What is the best way to achieve a count of number of rows within a region which have % sold below target in the example above?

Thanks

[v-piga-msft · Accepted solution]

Hi @po ,

I have a little confused about your requirement.

Do you want to count the the rows and the measure as a filter condition?

If it is, you could refer to my test.

If that is not your case, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[po]

Thansk for update