Filter a table based on output of a measure

[Anonymous]

Hi Team,

I have a Measure1 who's value changes dynamically if the value today is A tomorrow it may become B.

I have table and i want to filter all the values in this table Visual based on the output of the Measure1.

Is it possible to apply the output of the measure as a visual level filter to the table visual?

Regards,
Hema

[v-yangliu-msft]

Hi  @Anonymous ,

According to your description, I created some data to show:

Here are the steps you can follow：

1. Create measure.

Measure =
var _com=CALCULATE(MAX('Table'[Company]),FILTER('Table','Table'[Date]=TODAY()))
return
CALCULATE(SUM('Table (2)'[amount]),FILTER('Table (2)','Table (2)'[Company]=_com))

2. Result.

Today is November 27, 2020, so the result is

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous, Is the value just checking today's value vs yesterday's value. Or it like inventory , we need snapshot or rebuild

Appreciate your Kudos.

[Anonymous]

Hi Amit,

For Example the Company name toady is ABC CORP tom they may change the name of the company to XZY Limited.

i have written the measure in such a way that it will take the latest company name that they have defined in the config table.

Now i have a summary table and it should be filtered for the latest company name that will be the output of the Measure.

i cannot hard code the company name in the visual level filter.

Thanks in Advance 

Hema

[nvprasad]

Hi,

Yes, you can for the table visual. in the advanced filter condition, you can pass the condition on the top of the measure.

Ex: Measrue1 values > 0  apply filter

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad