Forum Discussion

amaniramahi's avatar
amaniramahi
Helper V
5 years ago

Dynamic Column/measure Value

Hi

 

I have a table as below

 

OrderBookPriceCover TypePublisher
Order1A10Hard coverPublisher 1
Order1B20PaperbackPublisher 1
Order1C30Hard coverPublisher 2
Order2D40Hard coverPublisher 3
Order2E50Hard coverPublisher 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

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    amaniramahi 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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