Visual as filter for my measure

[Anonymous]

Hey, 

Is it possible to take a visual as filter selection for my measure ?

I want to get a delta ratio for my Sales last Day and my Sales cumulative year. 

But I have product, which havent got a value of Sales last day (look at the picture) 

For the delta ratio (in %):  As a basis should be used only filtered or displayed values from the visual  

Measure  =    Sales[- cumulatve year] filtered by the visual /  Sales [- cumulatve year]  filtered by the visual- Sales [- last day]  -1 

I hope, that you can solve it 🙂 

[Anonymous]

hey,

the data table are my sample data... I only have these three colums (Produkt, Sales- last day, Sales- year)

If you cant see it or need more sample data, please tell me 😉 

Thanks for your support 

best wishes from Germany 

[Anonymous]

Hi @Anonymous ,

Sorry that I still not clear about your requirement... How do you want to filter the measure using the visual? Which measure do you want to be filtered by the visual? Has the measure been created? Could you please provide some raw data(exclude sensitive data) with Text format and some special examples to explain it with more details? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Ashish_Mathur]

Hi,

I have not been able to understand your question.  What exactly do you want?

[lbendlin · Accepted solution]

yes, that is possible.

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523