Forum Discussion
How to filter only specific column in table
Hi everyone, I'm working on a table, and I need to filter a data of specified range time in table. But not all the column, just a specific column. All the remaining column must keep current value.
As attached below.
2 column (only Hour by Date and Cost By Date will be afftected by a created date filter).
When I select 01/01/2020 - 01/12/2020, the result is
-Client Id = 1001, Hours: 50, CostValue: 80, Hour by date: 30, cost value: 50
- Client Id = 1002, Hours: 27, CostValue: 100, Hour by date : 15, cost value: 40
But now when I filter, all the data is affected.
Any one can help me on this. Thank you so much.
Hi, Anonymous
Sorry that I did not clearly understand from the first time.
I hope this time I understood correctly.
The new link is down below.
Hour by Date V2 =CALCULATE (SUMX (Query1,Query1[Hours]),FILTER (Query1,SELECTEDVALUE ( 'Table'[ClientId] ) = Query1[ClientId]))Cost by Date V2 =CALCULATE (SUMX (Query1,Query1[CostValue]),FILTER (Query1,SELECTEDVALUE ( 'Table'[ClientId] ) = Query1[ClientId]))
12 Replies
Hi, Anonymous
If it is OK with you, can you share the PBIX file?
Then, I can try to come up with a solution.
Thank you very much.
Hi Jihwan_Kim , Please visit the link to donwload, I don't know how to upload to this topic
filter.pbixHi,
Thank you for sharing.
I have looked into the file, but I was confused a bit about what you tried to achieve.
However, I tried to translate your initial question, which was that you do not want to filter the tables by a "CreateDate" slicer.
-Bottom Table: I think it is not affecting because there is no connection.
-Upper Table: I think the table and the slicer are coming from the same origin. So, if you do not want the slicer to affect it, please try to do it step by step as the below picture shows.Did I answer your question? Mark my post as a solution!