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
Moderator v-caliao-msft
Moderator

Re: Can I use Card value in my calculation?

@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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)