Filtering a table or matrix

[Anonymous]

Hi everyone,

Let's say I have a table with 3columns : labour cost, raw material cost, energy cost.

I want to display in a table or matrix those 3 columns, with some filters.
On line 1, I want to show the costs for item 1 without taxes.

On line 2, item 2 without taxes.

On line 3, the total with taxes.

I have to specify that the costs are in a table, and the items and the flag for the taxes are in another table. The 2 tables are not directly linked. There is an intermediate table betwen the 2.

I don't feel like I'm close to finding my way to the solution.

Any clue/advice ?

[v-jianboli-msft]

Hi @Anonymous ,

What does your intermediate table and taxes look like?

Does the first table you mentioned only have 3columns without item column or anything else?

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.