Can I use Card value in my calculation?

[Anonymous]

In my report, I have added two cards. 

1. Average sales 

2. Total number of Active listing 

Also, add some slicer to filter record in the card. Please check in the image. 

Image link =http://prntscr.com/f7bp9y  

Now I want to use this value and show below result 

For 12 month = [Total number of active listings] / ([average sales/12)

------------------------------------------------

I try one solution that I create Measures.

Measures One is Total number of active Listing

Measures Two is average Sales.

When I use both Measures in the Formula 

For 12 month = [Total number of active listings] / ([average sales/12)

In this case slicer filter is not working, Because "Active listing value" come with Two slicer and "average value"come with other two slicer.

[v-caliao-msft]

@Anonymous,

For a Card visual, we could add a column or measure into it. When add column into card visual, it will aggregate automatically. So if you want to use the value in card, you could create a measure that aggregate your column value.

What's you expected result? In your scenario, please provide us more detail information, so that we can make further analysis.

Regards,

Charlie Liao