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.
@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
User | Count |
---|---|
381 | |
228 | |
117 | |
107 | |
101 |