Slice Measure problem I think

[FrankWoody]

Good evening !!
First I have a table with following statuses

I need to count the amount of low and medium per country.

_Count. low = CALCULATE(COUNT(financials[Discount Band]),financials[Discount Band]="Low")

_Count. Medium = CALCULATE(COUNT(financials[Discount Band]),financials[Discount Band]="Medium")

 After that I need to count the amount of Lol that has Manufacturing Price]>5:

_Count. low and Manufacturing price >5 = CALCULATE(COUNT(financials[Discount Band]),financials[Discount Band]="Low", financials[Manufacturing Price]>5)

_Count. Medium and Manufacturing price >5 = CALCULATE(COUNT(financials[Discount Band]),financials[Discount Band]="Medium", financials[Manufacturing Price]>5)

Then build an array with the data:

the problem is that I would like to have a column with Status Qty. Low and Qty. Medium and that I could have a filter to filter only the ones that are > 5 of each. 

Download  

[v-mengzhu-msft]

Hi @FrankWoody ,

Not quite sure about your question, what kind of desired effect do you want to achieve? Like this?

If I misunderstand your meanings, please tell me in time. Thanks in advance~

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly