Dynamic Column/measure Value

[amaniramahi]

Hi

I have a table as below

Order	Book	Price	Cover Type	Publisher
Order1	A	10	Hard cover	Publisher 1
Order1	B	20	Paperback	Publisher 1
Order1	C	30	Hard cover	Publisher 2
Order2	D	40	Hard cover	Publisher 3
Order2	E	50	Hard cover	Publisher 1

Cover Type and Publisher are two slicers available.

I want to calculate the total amount of the order as long as one of its items are not filtered out by the slicers

ex.

If I filter for paperback then filtered for publisher 2 only, order 2 will be dismissed and the entire amount of order 1 will be calculated.

plus, I want to show a pie chart of the total amount calculated to show the share of the publishers

[Anonymous]

Hi @amaniramahi,

It sounds like you want to create a dynamic column based on filter effect, right? If that is the case, current power bi does not support creating a dynamic calculate column/table based on filter/slicer. They are host on different data levels and you can't use child level to affect its parent.

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[Fowmy]

@amaniramahi 

Can you share the expected answer? when you filter paperback then publisher 2, there is not combination here.