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...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

timoneill84,

Create a measure using DAX below and check if you get expected result.

Measure 2 = CALCULATE(COUNTA(Table1[ColumnName]),FILTER(Table1,Table1[ColumnName]="4x4 car"))/CALCULATE(COUNTA(Table2[ColumnName]),FILTER(Table2,Table2[ColumnName]="4x4 car"))


If the above DAX doesn't help, please share dummy data of the two tables and post expected result based on the dummy data.

Regards,
Lydia

 

timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago

Thanks Lydia

 

I'm getting the "Too many arguments were passed to the COUNTA function. The maximum argument count for the function is 1."

 

So one table would be like this for example:-

 

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              1

3 Door 4x4              1

 

The formula would basically need to sum the figures of rows which contain the text "4x4" (which is 2) from table two and divide by the count of the same text criteria for table one (so also 2) and then x100 making the answer here 100%.

 

I've realised there is no link / common field between the tables, does this matter?

 

Thanks 

    • 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