Forum Discussion

majdkaid22's avatar
majdkaid22
Helper V
8 years ago
Solved

Volume by Volume range

Hi guys,   am trying to breakdown my MTD Volume into Volume range category that I created in a disconnected table    and created the below measure  Volume B2B by Range = CALCULATE([Volume ...
Need Help
  • majdkaid22's avatar
    majdkaid22
    8 years ago

    Not sure if this is a workaround or the only way. 

     

    The below got me the data I need

     

     

    Dax Table

    Monthly Volume = SUMMARIZE('Xcore All tables',Calander[Month],'DivMT4_Users'[LOGIN],'DiMT4_Users'[Client Name],'DiMT4_Users'[COUNTRY],"Monthly Volume",CALCULATE(SUM('Xcore All tables'[USD_volume]),'Master Accounts'[Is Volume Active]=TRUE(),'DiMT4_Users'[Is Di Account]=FALSE(),'Divisa MT4_Users'[Entity]="DCAM" || 'Divisa MT4_Users'[Entity]="DCUK"))

    Measure

    Volume B2B by Vol Range = CALCULATE(SUM('Monthly Volume'[Monthly Volume]),FILTER('Monthly Volume','Monthly Volume'[Monthly Volume]>=MIN('Volume Ranges'[Start])&&'Monthly Volume'[Monthly Volume]<MAX('Volume Ranges'[End])))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share the workbook please.