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

JK_29's avatar
JK_29
Frequent Visitor
4 years ago

Hi,

I tried using the measure for local currency amount, however, i am unable to get the graph in same fashion.   What could be wrong?  Here is the measure that I am using

LocalCurr.agg = CALCULATE ( SUM ( AR_details[Amount in Local Currency]), FILTER(Measuretable,[DueBucket]= SELECTEDVALUE('Bucket Sizing'[Bucket])))

 

 

v-easonf-msft's avatar
v-easonf-msft
Community Support
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