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 B2B],FILTER('Xcore All tables','Xcore All tables'[USD_volume]
>=MIN('Volume Ranges'[Start])&&'Xcore All tables'[USD_volume]<MAX('Volume Ranges'[End])))

While am expecting when applying Month and account in row as category,that I will get for account x their volume in one of the Volume ranges. But am getting some accounts with Volumes in more than 1 Volume range.

 

 

 

What am looking to achieve is Total Volume traded to be sliced by Volume range. For example the above highlighted row, should be under the category of 500-1000M as the total volume is 597M

 

 

Am not sure what am missing to add in the measure formula? 

 

appreciate any help 

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])))

2 Replies

  • majdkaid22's avatar
    majdkaid22
    Helper V
    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])))