cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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. Screenshot_2.jpgScreenshot_4.jpgScreenshot_5.jpg

1 REPLY 1
Microsoft
Microsoft

@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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors