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
pitucc
Helper I
Helper I

Sum, slicer, filter and average and weighted index

Hello All,

 

I am trying to compute weigthed values that change dynamicaly with the slicer i selectin my report

 

One table, 4 column : Name; region, price ; Volume 

 

I want to compute the weighted price  by volume  

for "a" :  5* 100  / ( sum all volume = 755) 

"b": 1* 105 / 755 

etc... 

I managed to have something that works but if i choose to slice by region for instance, my weighted price  by volume  remain the same same if I want to select only a b c with a slicer. I tried with calculate and  allselected, all, allexecpt, but i getting crazy... 

 

Thanks for your help 

Capture.PNG

1 ACCEPTED SOLUTION
pitucc
Helper I
Helper I

finally found a solution : 

SUMX(ALLSELECTED(Table1);Table1[Volume])

 

View solution in original post

1 REPLY 1
pitucc
Helper I
Helper I

finally found a solution : 

SUMX(ALLSELECTED(Table1);Table1[Volume])

 

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.