Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

split column value based on another column

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

Help appreciated

Greg_Deckler
5 years ago
Anonymous Try

PR Compliance -over val =

CALCULATE(

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

'PR Details'[PR]="Within"

)

5 Replies

Greg_Deckler
Community Champion
5 years ago
Anonymous Try

PR Compliance -over val =

CALCULATE(

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

'PR Details'[PR]="Within"

)
- Anonymous
  Not applicable
  4 years ago
  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
goncalogeraldes
Super User
5 years ago
Anonymous
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
- Anonymous
  Not applicable
  4 years ago
  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
Tanushree_Kapse
Impactful Individual
5 years ago
Hi Anonymous ,

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

Related content