Forum Discussion
Using a measure for Bucketing data
Your "amount in local currency" has to be a measure that is based on the logic for each item in your bucket table - whatever that logic is.
Hi， JK_29
The filter in your formula is performed in a Table called ‘measuretable’, you need replace it with fact table ’AR_details‘．
Please check the formula in the pbix file I provided before.
Best Regards,
Community Support Team _ Eason
Thanks Ibendlin, I tried the solution through an independent table. However, my requirement is to sum the amount in local currency by the buckets defined. I am unable to get that since the buckets table is not linked to AR table. How do we achieve a bar chart with buckets in x axis and amount in local currency in Y axis?
Your "amount in local currency" has to be a measure that is based on the logic for each item in your bucket table - whatever that logic is.