Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Can I use Card value in my calculation?

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.

Need Help

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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