Forum Discussion

160475's avatar
160475
Helper I
3 years ago
Solved

dax formula

dears,

how can i devide the below values to the previous column total ??

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi 160475 ,

     

    You can try this measure.

    Measure 2 = IF(ISINSCOPE('Table'[brach #]),[Measure],SUMX('Table',[total tickets]))

    If this is not what you want, please provide me with some simple sample data and the desired results.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    160475 Try:

    Total Tickets Measure = 
  VAR __Total = SUMX(SUMMARIZE('Table',[branch #],"__Measure",[Measure]),[__Measure])
  VAR __Result = DIVIDE([total tickets], __Total)
RETURN
  __Result
    • 160475's avatar
      160475
      Helper I
      3 years ago

      thank you for your reply but the results returns 1.0 see the table below :

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi 160475 ,

     

    You can try this measure.

    Measure 2 = IF(ISINSCOPE('Table'[brach #]),[Measure],SUMX('Table',[total tickets]))

    If this is not what you want, please provide me with some simple sample data and the desired results.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.