split column value based on another column

[THENNA_41]

i have two column 

PR Compliance : 

PR                         PR DATA

Within                      4

Over                         2

Over                         2

Within                      4

Within                      4

i am trying split  value avergat  based PR value i  have used following measure 

PR Compliance -over val =

CALCULATE(

AVERAGE('PR Details'[PR ]),

'PR Details'[PR]="Within"

)

i am getting Error  "The function AVERAGE cannot work with values of type String." any 

[Tanushree_Kapse]

Hi @THENNA_41 ,

Mark this as a solution, if I answered your question. Kudos are always appreciated.

Thanks

[goncalogeraldes]

@THENNA_41 

PR Compliance -over val =

CALCULATE(

AVERAGE(VALUE('PR Details'[PR ])),

'PR Details'[PR]="Within"

)

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

[THENNA_41]

@goncalogeraldes 

Month        PODetails

May            over

May            over

May            within

May            over

June            within

June          within

June           over            

July            within

My percentage  want month wise 

Month       Over          within           Grand Total 

May            75%         25%                  100%

June            25%         75%                  100%

any idea month wise percentage ? thanks in advance

[Greg_Deckler · Accepted solution]

@THENNA_41 Try

PR Compliance -over val =

CALCULATE(

AVERAGE('PR Details'[PR DATA]),

'PR Details'[PR]="Within"

)

[THENNA_41]

@Greg_Deckler   i have month wise text count value like 

Month        PODetails

May            over

May            over

May            within

May            over

June            within

June          within

June           over            

July            within

My percentage  want month wise 

Month       Over          within           Grand Total 

May            75%         25%                  100%

June            25%         75%                  100%

any idea month wise percentage ? thanks in advance