Forum Discussion

rashidanwar's avatar
rashidanwar
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Creating dynamic categories using DAX

Hi everyone, I have a problem that is more mathetical infact. I would appreciate if someone helps. I have a table as shown below  orderline_id             order_id            qty 1         ...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    rashidanwar Try the alternate formula I posted:

    Measure = 
    VAR __qty = SUM('Table'[Column1])
    VAR __Mod = MOD(__qty,9)
RETURN
    IF(__Mod = 0, DIVIDE(__qty,9), TRUNC(DIVIDE(__qty,9))+1)