Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

dividing row values with subtotal

i want to divide each row of TY_Actual with its subtotal i.e 110679.54 to get the %. i created 1 measure and it was showing correct value but the catch was the value was getting displayed in total row rest rows were empty

    

  • Hi, Anonymous 

    sorry, in above code there are some changes needed and i forgot to write it 
    try below code 

    result = 
    
    var a = sum('yourtablename'[TY_Actual])
    var b = calculate ( sum('yourtablename'[TY_Actual],
                      removefilters('yourtablename')
                       )
    
    return
    divide(a,b)
    
    
    
    
    

     

    if it not work then provide some sample data

6 Replies

  • Hello Anonymous ,

     

    Could you give more info on the measure you tried ?

     

    In a first look, I could suggest in your measure to calculate the SUM of TY_Actual filtering by DayPart, and to calculate the same SUM but selecting all your table with ALL or ALLSELECTED depending on your need.

     

    Then you can divide the filtered sum by the second and format your measure as %.

     

    It could look like :

     

    MyPercentage = 
    
    VAR FilteredSum = CALCULATE (
    SUM('YourTable'[TY_Actual], 
    FILTER('YourTable', 'YourTable'[Daypart] = SELECTEDVALUE('YourTable'[Daypart])
    )
    
    VAR GlobalSum = SUM('YourTable'[TY_Actual])
    
    RETURN DIVIDE(FilteredSum, GlobalSum)

     

    Hope it helps

     

    Vincent BLOT
    Did I answer your question? Mark my post as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable

      not working sir

  • Dangar332's avatar
    Dangar332
    Resident Rockstar

    Hi, Anonymous 

     

    try below code 
    just adjust your table and column name

     

    result = 
    
    var a = sum('yourtablename'[TY_Actual])
    var b = calculate ( sum('yourtablename'[TY_Actual],
                      removefilters('yourtablename')
                       )
    return
    divide (a,b)

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      not working

       

      • Dangar332's avatar
        Dangar332
        Resident Rockstar

        Hi, Anonymous 

        sorry, in above code there are some changes needed and i forgot to write it 
        try below code 

        result = 
        
        var a = sum('yourtablename'[TY_Actual])
        var b = calculate ( sum('yourtablename'[TY_Actual],
                          removefilters('yourtablename')
                           )
        
        return
        divide(a,b)
        
        
        
        
        

         

        if it not work then provide some sample data