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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
anupaminfo
Frequent Visitor

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
anupaminfo
Frequent Visitor

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

@anupaminfo , 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 $])

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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