Count from results in a measure

[jd-tb]

I have a calculated table, part of it shown here. I have a slicer filtering by date

Affiliate Location	Received to Completed Score %	Received to Completed Rank Level
Toronto	100	1
Montreal	100	1
Boston	88	2
Vancouver	79	3
Los Angeles	55	4
New York	40	4

ReceivedToCompletedScore % = [ReceivedToCompletedFilter]/[JobCompleteFilter]

ReceivedToCompletedRankLevel = IF ([ReceivedToCompletedPercentFilter]=1,1,IF([ReceivedToCompletedPercentFilter]>=0.86,2,IF([ReceivedToCompletedPercentFilter]>=0.76,3,IF([ReceivedToCompletedPercentFilter]>=0,4,"n/a"))))

I have 68 total affiliates with their scores
I have managed to rank them with a rank level of 1 to 4 based on the rank level Criteria shown here

Rank Level Criteria

Rank level 1 is 100%

Rank level 2 is 86 to 99%

Rank level 3 is 75 to 85%

Rank level 3 < 75%

The result I need is to show the percentage of affiliates by ranklevel

Example

Rank level 1 is a%

Rank level 2 is x%

Rank level 3 is y%

Rank level 4 is z%

Any help would be greatly appreciated.

Jd

[Portrek]

Hi, try the measure below.

measure = DIVIDE(
COUNT(Table[Received to Completed Rank Level]),
CALCULATE(
COUNT(Table[Received to Completed Rank Level]),
ALL(table) ),
0)

choose the % format.

Best regards.

[jd-tb]

Hi Portrek,

Thank you for the help.

I have tried this formula you provided and it returns a 1 or 100%

i think my problem is that the column I have for Recieved to Completed rank Level is created from the following measure 

ReceivedToCompletedRankLevel = IF ([ReceivedToCompletedPercentFilter]=1,1,IF([ReceivedToCompletedPercentFilter]>=0.86,2,IF([ReceivedToCompletedPercentFilter]>=0.76,3,IF([ReceivedToCompletedPercentFilter]>=0,4,"n/a"))))

and it is a true false Column? I am not sure.

I have also tried these and they did not work either.

ReceivedToCompleted_GroupLevels1 = CALCULATE(IF([ReceivedToCompletedRankLevel]=1,1,0))

and

ReceivedToCompleted_GroupLevel1Count = sumx('Date',[ReceivedToCompleted_GroupLevels1])

Thank you for your help.

Jd

[Ashish_Mathur]

Hi,

I'd like to help.  Please describe the question, share the raw data (not a calculated table) and show the expected result.

[jd-tb]

Hi Ashish,

I have created a scaled down version of my file.

https://www.dropbox.com/s/mz5fpdvirwrr88o/RankRate.pbix?dl=0

I need to create a formula that gives me the result
Locations with a score of 4 30.00%
Locations with a score of 3 20.00%
Locations with a score of 2 40.00%
Locations with a score of 1 10.00%

Thanks for helping.

Jd

[jd-tb · Accepted solution]

I Managed to figure this out with this formula.

TrueCount1 =

VAR vTable =

ADDCOLUMNS(

    'Location Scores',

    "rate1", [RateRank]

)

RETURN

COUNTROWS(

    FILTER(

        vTable,

        [rate1] = 1

    )

)