Forum Discussion

timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago
Solved

Monthly Percentage

Hi all   I'm new to Power and have only done three of the tutorials so I apologise if the question has a simple answer!   How would I go about showing the total number of records / rows that read...
timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago

Hi

 

Thanks for that.

 

I've managed to replicate the check columns and they're working.

 

Having issues with the measure formula however and the overall measure %. Should there not be a sum function in there to add up the figures in table two that match the text search criteria / check?

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    timoneill84,

    I am not clear about your requirement, could you please share expected result based on the dummy data you share?

    Regards,
    Lydia

    • timoneill84's avatar
      timoneill84
      Frequent Visitor
      8 years ago

      sorry, so here is the dummy data again (i've changed the figures that need to be summed in table two):-

       

      12345678      001234566     2      001234566 2       5 Door Hatchback

      12345679      001234567     4      001234567 4       5 Door 4x4

      12345673      001234569     7      001234569 7       3 Door 4x4

       

      second table:-

       

      5 Door Hatchback   10

      5 Door 4x4              6

      3 Door 4x4              5

       

      formula would need to do 2 (as there are 2 4x4s) divided by 11 (6+5 as the sum for text criteria containing 4x4) x100 to get a percentage figure.

       

      Hope that makes sense.