Create visual based on filter

[Harry_Tran]

Hi everyone,

I have a table with Invoice and Product_ID.

If an Invoice contains either 'A' or 'C' AND either 'Z123', 'Z234', or 'Z345'. It will meet the requirement.

I Create a measure to filter out with Invoice meet the requirement

I want to create a table with Invocie (which meet the requirement) and Product_ID

The problem that I have is If I apply Product_ID to table, all Invoice will be "DO NOT meet the requirement".

How can I create a table only show Invoice Meet the requirement and Product_ID. I do not want Measure in my table.

Thank you so much

[Anonymous]

Hi @Harry_Tran,

Current power bi not able to create dynamic calculated column/table based on filter or slicer.
They can be achieved dynamic tag in measure expression but if you use these into calculated column or table, the result will be fixed and not dynamic changes.

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

[MFelix]

Hi @Harry_Tran ,

How is the measure you created for the meet requirement?

Another questions is what do you mean by I do not want measure in my table?

The solutions passes trough a measure, a calculted column but then dependending on the way you want to setup your visual you may need to add a measure, or create a table with the Product_ID and the Meet or do Not meet, but again if you go to a level of invoice you may need to add a measure.