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.

      • timoneill84's avatar
        timoneill84
        Frequent Visitor
        8 years ago

        Hi

         

        I'm just trying to modify the check formula which currently reads:-

         

        check = IF(ISERROR(SEARCH("4x4",Claims[Vehicle Type])),1,0)

         

        How do I get it to search for multiple text criteria instead of just 4x4? so say search for 4x4 OR apples and return 0 next to those rows?

         

        Thanks