hi

[abc_777]

HI

I have two tables that has two column values

i have two measures

I want to create a measure that can swich and show values  when I select column value from first table

and

when i select column values of second table then in that new measure it would show the values of second measure

Total Quantity in Piece (Measure) = CALCULATE

(SUMX('bm_retail_t sale', 'bm_retail_t sale'[SQTY] - 'bm_retail_t sale'[RQTY]))

measure is for sale_store Table

and 

Total Measure Multi = (SUM('bm_retail_t sale'[SQTY]) - SUM('bm_retail_t sale'[RQTY])) * SUM('bm_retail_t ssummary'[NET_AMT])

is for summart_store table

so i want a new measure that can  switch these two measue when select sale_store and summary_store accordingly

Two tables, Two column values, two measure switching 

New Measure = 

 switch,

Total Quantity in Piece (Measure) ,

Total Measure Multi

sample file attached

thanks

[v-stephen-msft · Accepted solution]

Hi @abc_777 ,

It looks like you're going to create separate field tables for these two slicers. 

Because they are two fields that are not connected, the slicer chooses not to interfere with each other.

Then specify the priority in the formula, and use the SELECTEDVALUE function or the ALLSELECTED function to call the result of the slicer selection.

I made a simple sample for reference. Hope it helps you.

Best Regards,

Stephen Tao

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