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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Filter the All the dimesion and measure of the table based on slicer selection.

Hello All,

 

I have a table which has dimensions and measures. I need to filter them based on a slicer which is "PO Value". I need only those rows which are greater than the Selected "PO Value". As of now, I can see the rows both the rows which is greater than selected PO value and less than that.

For Example, In the below snip, I want single row has to be shown on table instead of all of them. Here PO Value is a custom table and not connected with any other tables in modeling.

This is how, I am calculating measures = 

PO $ final = CALCULATE([PO $],FILTER(V_PO_APPROVAL,SUM(V_PO_APPROVAL[POLINEAMT]) > SELECTEDVALUE(POValue[Value])))
 
I didn't find any way to restrict the dimensions.

Please guide me...

 

anupaminfo_0-1673854362245.png

 

2 REPLIES 2
Anonymous
Not applicable

Hi @amitchandak ,

 

Thanks for the solution.

But this is working only when PO_ID and "PO $ final" is present in table. When I drag other dimension again it is behaving like older.

If I use Buyer as 2nd dimension, Everything failed. How can I modify this measure for multiple dimensions.

 

Measure definition:- 

test =
CALCULATE(SUM(V_PO_APPROVAL[POLINEAMT]),ALLEXCEPT(V_PO_APPROVAL,V_PO_APPROVAL[PO_ID],V_PO_APPROVAL[BUYER_NM]))
 
Val = Sumx(FIlter( values(V_PO_APPROVAL[PO_ID]) ,[test] > SELECTEDVALUE(POValue[Value]) ), [test])
 
Please help me out for more than one dimension because i need to use 3-4 dimensions.

anupaminfo_0-1673859221945.png

anupaminfo_1-1673859886089.png

 

 

amitchandak
Super User
Super User

@Anonymous , You have to use a filter at level , asusuming [PO $] is a measure

 

create a measure

M1 =SUM(V_PO_APPROVAL[POLINEAMT]) 

 

or

 

M1 = calculate(SUM(V_PO_APPROVAL[POLINEAMT]) , allexcept(V_PO_APPROVAL,V_PO_APPROVAL[PO Number]) )

 

 

Then Create a measure like

PO $ final = Sumx(FIlter( values(V_PO_APPROVAL[PO Number]) ,[M1,> SELECTEDVALUE(POValue[Value]) ), [PO $])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!