- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 =
Please guide me...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:-
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 03-07-2024 04:38 AM | ||
Anonymous
| 07-03-2024 03:42 PM | ||
03-26-2024 02:32 PM | |||
03-11-2024 11:00 AM | |||
Anonymous
| 10-31-2022 05:38 AM |
User | Count |
---|---|
137 | |
107 | |
84 | |
60 | |
46 |