The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!