Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Good morning everyone,
Currently, I have a series of data segmenters and two cards. These cards change value when the data segmenters values are changed.
I need a third card that divides the values of card 1 and 2. Is this possible with DAX? Is there any way to filter in DAX using the value of the filtered columns?
The problem is that the value of card 1 and 2 depend on several selector values. Each value is averaged.
I need, once these values have been calculated, to extract the data from each card and use it in a third one. The value of card 1 and 2 is not registered anywhere as a value.
Hi @clozanosevilla ,
The most common case is to get the value in the slicer via selectedvalue() and then do a calculation to change the value in the other cards.
SELECTEDVALUE function - DAX | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @clozanosevilla if you are using measure in card it is possible in third card to be like
Card 3 measure = Card 1 measure / (divide sign) Card 2 measure
For some other scenario, there is no addinal details from your side.
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
10 | |
10 | |
9 | |
8 |
User | Count |
---|---|
17 | |
13 | |
12 | |
11 | |
9 |