https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-measure-with-a-filtered-card-value/m-p/3883133#M151544 <P><SPAN>Hello,</SPAN></P><P>I've created two tables that mimic each other with data from auctions. From this, I've developed two sets of filters, such as the auction name, auction region, and the date the auction took place. Additionally, I have two field parameter single selection slicers that allow the user to select a value they want from the specified auction, such as number of items sold, run, sale price, average condition, etc.</P><P>The user can make selections on all of these to get two fields selected in the field parameters returned on different cards. For example, based on the first set of slicers, I can get the total sold in auction 1 from the past week (e.g., 36), and on the other card, I can get the total items run from auction 2 in the past month (e.g., 300).</P><P>Now, I'm looking to create a card that finds the difference between these values (-270). However, I cannot find a way to get the values from the first two cards in a measure in order to create a measure that subtracts the two of them. Is there a way to create this third card?</P> Wed, 01 May 2024 15:54:37 GMT Hurricane52 2024-05-01T15:54:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-measure-with-a-filtered-card-value/m-p/3883133#M151544 <P><SPAN>Hello,</SPAN></P><P>I've created two tables that mimic each other with data from auctions. From this, I've developed two sets of filters, such as the auction name, auction region, and the date the auction took place. Additionally, I have two field parameter single selection slicers that allow the user to select a value they want from the specified auction, such as number of items sold, run, sale price, average condition, etc.</P><P>The user can make selections on all of these to get two fields selected in the field parameters returned on different cards. For example, based on the first set of slicers, I can get the total sold in auction 1 from the past week (e.g., 36), and on the other card, I can get the total items run from auction 2 in the past month (e.g., 300).</P><P>Now, I'm looking to create a card that finds the difference between these values (-270). However, I cannot find a way to get the values from the first two cards in a measure in order to create a measure that subtracts the two of them. Is there a way to create this third card?</P> Wed, 01 May 2024 15:54:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-measure-with-a-filtered-card-value/m-p/3883133#M151544 Hurricane52 2024-05-01T15:54:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-measure-with-a-filtered-card-value/m-p/3883736#M151553 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="735304" data-lia-user-login="Hurricane52" class="lia-mention lia-mention-user">Hurricane52</a>&nbsp;if you need difference for two different measures, simple create third measure like</P> <P>measure 3 = [measure 2]-[measure 1]</P> Wed, 01 May 2024 20:11:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-measure-with-a-filtered-card-value/m-p/3883736#M151553 some_bih 2024-05-01T20:11:37Z