Making a Bar Graph by Selecting Two Measure Values

[diegolima]

Hello guys, how are you?

I need make a bar graph like this:

And my table is like this:

I need selected one number for day of column "Equipamento" that don't be in blank in the column "Conteudo" and that column "MEDIA" have value above 8000, but my user always will go selected this ranhe of 7 days, for this I need that this information has ocurred for 3 days. In short, in the range of 7 days, select "Equipamento" with an average above 8000 in the column "MEDIA" for 3 days.

Can anybody help me?

Thank you all!

[v-yalanwu-msft · Accepted solution]

Hi, @diegolima ;

You could create a flag measure like below:

flag = IF(CALCULATE(AVERAGE([MEDIA]),FILTER(ALLSELECTED('Table'),[Date]=MAX([Date])&&[Conteudo]<>BLANK()))>8000,1,0)

Then apply it into filter:

The final output is shown below:

If it's not right, please share you file after removing sensitive information.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.