Forum Discussion

Cotter2000's avatar
Cotter2000
Frequent Visitor
9 years ago

Revenue by Customer & Year, Filtered Dynamically by additional field

Hi everyone,   New to Dax here.  I have four fields:   Customer, Product Format, Price, Transaction Year   For each customer AND transaction Year, I'm trying to calculate a sum of Price for any...
Need Help
Cotter2000's avatar
Cotter2000
Frequent Visitor
9 years ago

Hi GilbertQ

 

Thanks for the link.  I read through your post and tried what you suggested.  However, if I want to use the Bands on my X or Y axis to show total revenue per band, can I do that using your approach?  The 'Amount Bands' is a measure and I can't get that to work in the Axis portion of a chart.  I tried it as a Column instead but that didn't work either. 

 

Thanks for any help.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi Cotter2000

     

    The way that I implemented it was to use the dynamic banding as a measure. I would then use any of my data in the columns to then be defined by the measures. In doing it this way it means that I can literally use any column and if I have my banding correct created it would drop then into each of the banding buckets.

     

    And that also gives you the ability to then use any column on the X or Y Axis.