Add manual comment in table after filtering data

[Anonymous]

Dear Community,

Need your help, Iam facing issue adding "comment" after filtering columns "FDD Support, Device Type and 4G capability".

After applying filter => Add column => Column ="3G capable". then 3G capable text is applied on complete "comment" column rather than only filtered rows. How can I type seperate text after filtering data? 

P.S. "FDD Support, Device Type and 4G capability" columns are taken from other sheets using LOOKUP function.

Br,

Amir Ansari

[Anonymous]

Hi @Anonymous,

In fact, power bi does not support create a dynamic calculate column/table that responds with filter/slicers that host on the visual data levels. You need to use measure expression instead.

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