Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

% Of total

Do you have any ideas on how I display the drill down as a percentage of the date total? e.g    0-1 days - 42706 as a percentage of 42764 1-2 days 58 as a percentage of 42764     Thanks a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi NewbieJono 

     

    Thanks for the reply from bhanu_gautam  and AilleryO .

     

    NewbieJono , the following steps are for your reference: 

     

    Sample:

     

    Create a measure as follows

     

    Measure = 
VAR _sum = CALCULATE(SUM('Table'[Value]), ALL('Table'))
RETURN
IF(
    ISFILTERED('Table'[Type]),
    FORMAT(SUM('Table'[Value]) / _sum, "0.00%"),
    SUM('Table'[Value])
)

     

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

NewbieJono , You can create a measure to calculate the percentage of each drill down category relative to number of days and pull that measure in visualization

  • NewbieJono's avatar
    NewbieJono
    Post Partisan
    2 years ago

    sorry what would that look like?