cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
FrankWoody
Helper I
Helper I

Slice Measure problem I think

Good evening !!
First I have a table with following statuses
tABLE. 1.png
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:

FrankWoody_0-1663203543533.png
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. 

FrankWoody_1-1663203724571.png

Download  

 

 

1 REPLY 1
v-mengzhu-msft
Community Support
Community Support

Hi @FrankWoody ,

 

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

vmengzhumsft_0-1663318664924.png

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors