Forum Discussion
majdkaid22
Helper V
Helper VVolume 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 ...
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])))
majdkaid22Helper V
Helper VNot 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])))