Forum Discussion

xuexi1890's avatar
xuexi1890
Icon for Helper I rankHelper I
7 years ago
Solved

Middle number Qty wise

Hello, I want to use a measure to extract a middle price at Qty wise, and respond to the filters (Year, sales area etc.) below is a summary table: Price           Sum of Resale Qty                ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi xuexi1890 ,

     

    You can create measures like DAX below.

     

    % of Accu. Resale Qty/Grand Total = CALCULATE(DIVIDE(SUM('Table'[Sum of Resale Qty]),CALCULATE(SUM('Table'[Sum of Resale Qty]),ALL('Table'))),FILTER(ALLSELECTED('Table'),'Table'[Price]<=MAX('Table'[Price])))
 
Middle number Qty = CALCULATE(MIN('Table'[Price]),FILTER(ALLSELECTED('Table'),'Table'[% of Accu. Resale Qty/Grand Total]>=0.5))

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

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

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

Hi xuexi1890 ,

 

You can create measures like DAX below.

 

% of Accu. Resale Qty/Grand Total = CALCULATE(DIVIDE(SUM('Table'[Sum of Resale Qty]),CALCULATE(SUM('Table'[Sum of Resale Qty]),ALL('Table'))),FILTER(ALLSELECTED('Table'),'Table'[Price]<=MAX('Table'[Price])))
 
Middle number Qty = CALCULATE(MIN('Table'[Price]),FILTER(ALLSELECTED('Table'),'Table'[% of Accu. Resale Qty/Grand Total]>=0.5))

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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