Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
3 years ago
Solved

hi

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
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.