How to calculate 2 cards value into 1 card when the 2 cards are filtered

[Anonymous]

Hi

I have 2 cards with filtered by date as below:

Card 1 in page 1:

Filtered by year 2023

Filtered by year 2024

Card 2 in page 2:

Filtered by year 2023

Filtered by year 2024

And both of this card data source are from different excel table, and they are all based on 2 pages in PBI desktop, now I would like to have 1 card that can show the value that Card 2 in page 2 divided by Card 1 in page 1 as percentage and locate at page 2 in one new card, is that possible?

And when filter changed, is that possible new cards value will change accordingly?

[Ritaf1983]

Hi @Anonymous 
Yes, you should create dynamic measures instead of a hardcore filter.
for example for the current year 
Measure 1 = sum(yourtable[column])

Measure 2 = calculate ([measure1], previousyear([date])

for more information please refer to the linked video:

https://www.youtube.com/watch?v=VLOHvQyCKWo

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

Hi Rita,

Thank you for your prompt reply, I have one question that I want to make the new result card interactive, becuae for Card 1 in page 1 users may select year 2023 or 2024 or 2021, and Card 2 in page 2 users may select 2023, 2022, 2021 by their wish. The new card has to display the divied value between those cards which has the filter can be interacted by users.

[Ritaf1983 · Accepted solution]

@Anonymous 
The solutions I gave are dynamic according to selection...
You can also use selectedvalue function to "catch" a users selection

https://www.youtube.com/watch?v=jnZ7pfuzvJ4

and manipulate it ...
For more detailed suggestions 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523