cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sallemongp Frequent Visitor
Frequent Visitor

Maintaining a value despite a filter

Hello,

First of all, thank you to those who will answer me.

 

The goal here is to keep the value of a "mother line" unchanged. While a filter will be applied to the items that compose it:

A quick exemple below:

Actually i have a dataset like this.

I would like to don't have the first row and have my expected value (and weighted value) on the filtered Item.
And in the case where there is no filter i woul like these value on the first Item.

 

image.png

 

                 

Actually i can only have this:

I have just create a table with only the expected and the ID and a table with the ID, The Item number and the quantity.
And i have attribute on the Item number 10 the Expected value.

However if i put a filter on the Item 20, 30 ... I naturally have an empty field for the expected

 

image.png

 

 

Any suggestion ?

 

Thank you in advance.

 

3 REPLIES 3
v-danhe-msft Super Contributor
Super Contributor

Re: Maintaining a value despite a filter

Hi @sallemongp,

From your description, I could not understand what your want? Could you please post your desired result if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
sallemongp Frequent Visitor
Frequent Visitor

Re: Maintaining a value despite a filter

Hi V-Danhe,

 

I would like something like this:

 image.png

 

image.png

image.png

 

And when I tick the item 20, 30, 40 ..... I would like to  keep the expected.
Actually this work only when i tick the item 10.

(I don't want to have the expected value on each row when no filter is ticked because for the users that could be disturbing)

 

My apologies if I'm not clear in my explanations.

 

Thank you in advance

v-danhe-msft Super Contributor
Super Contributor

Re: Maintaining a value despite a filter

 Hi @sallemongp,

From your data structure, I am afraid you could not achieve your excpeted result, due to there is no data related to item 20, 30, 40... in excpeted column, so when you chose the other ietm, the result should be blank.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 261 members 2,974 guests
Please welcome our newest community members: