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

[Anonymous]

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...

[Anonymous]

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.

[amitchandak]

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