Forum Discussion

JK_29's avatar
JK_29
Frequent Visitor
4 years ago
Solved

Using a measure for Bucketing data

I have two tabular sets as listed below, table A and table B.  Both the tables are connected using column assignment in table A and column Billing Doc in table B. Table A   ID Doc Document Da...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi， JK_29 

You need to enter a an independent table ‘Bucket’.

The ‘Bucket’ table is not linked to AR but you can create a new meausre based on these two tables.

Please add a measure like below and apply it to the x-axis.

Amount in Local Currency =
CALCULATE (
    SUM ( 'Table A'[Amount in Doc Currency] ),
    FILTER ( 'Table A', [DueBucket]=SELECTEDVALUE ( 'Due Bucket'[Bucket] ))
)

Best Regards,
Community Support Team _ Eason