Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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])))
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])))
Hi,
Share the workbook please.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |