Forum Discussion

JP1983's avatar
JP1983
Icon for Helper II rankHelper II
8 years ago
Solved

banding on measure value

hi i am new to power BI and DAX fucntionalities.I am trying to create banding on measure values and use the banding on slicer. i followed the steps in https://exceleratorbi.com.au/banding-in-dax/  ...
Need Help
  • MattAllington's avatar
    MattAllington
    8 years ago

    The banding technique you have used from my website works on columns of data, not measures. 

JP1983's avatar
JP1983
Icon for Helper II rankHelper II
8 years ago

yes i tried and i only get one banding 10

JP1983's avatar
JP1983
Icon for Helper II rankHelper II
8 years ago

when i added into the tabular report i get some incorrect values.attached screenshot

  • JP1983's avatar
    JP1983
    Icon for Helper II rankHelper II
    8 years ago

    attached screenshot with both column (banding) and measure (measure) on query 1.Measure works fine but not column :(

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      8 years ago

      What data is in the column query1[claims-count]?

      • JP1983's avatar
        JP1983
        Icon for Helper II rankHelper II
        8 years ago

        claims_count is another calculated measure which count the claims...

        Look at the banding measure and column in the screenshot.