Forum Discussion

FrankWoody's avatar
FrankWoody
Helper I
3 years ago

Slice Measure problem I think

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  

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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