Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Mihaw
Regular Visitor

sum quantity by selectedvalue of dropdown

Hello,

 

I couldn't find the solution although it seems easy to do....

Here's the Data (simplified) :

Mihaw_0-1677081086911.png


I'm using a dropdown like this to select a month (and not a slicer) : 

Mihaw_1-1677081355762.png

And what I want to do with measure is :

Sum(Quantity) where year = 2023 and type = "Sale" and month between 1 and SELECTEDVALUE(Data[Month])
The Result should be :

Nike0
Hummel500


Thank you. 

2 REPLIES 2
Padycosmos
Solution Sage
Solution Sage

amitchandak
Super User
Super User

@Mihaw ,

Measure = calculate(Sum(Table[Quantity]), filter(Table, Table[year] = 2023))

 

if the month slicer is from this table. then it will filter

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.