Volume by Volume range

[majdkaid22]

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 

[majdkaid22 · Accepted solution]

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]

Hi,

Share the workbook please.