Forum Discussion

a3810's avatar
a3810
New Member
2 years ago
Solved

Calculating a ratio based on partial text values

Sorry if this question seems too simple, but I am looking for a way to insert a quick measure which calculates the ratio of certain values.   Worker Service Cost James Initial serv...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Share the download link of the PBI file with the 3 visuals already built there.

amitchandak's avatar
amitchandak
Super User
2 years ago

a3810 , based on what I got

 

Divide(

Calculate( Sum(Table[Cost]), filter(Table, containsstring(Table[Service],"Initial"))) , Sum(Table[Cost]) )

 

or

 

Divide(

Calculate( Count(Table[Service]), filter(Table, containsstring(Table[Service],"Initial"))) , Count(Table[Service]) )

a3810's avatar
a3810
New Member
2 years ago

Thanks Amit.

 

I have used the second option, however I get the error saying that 'To use special characters in a measure, enclose the entire name in brackets ( [] ) and add a ] to any closing brackets in the name. 

 

Is the issue in my table or sheet names? Here is my input.

 

Divide(

Calculate( Count(Master Activity Report[Item]), filter(Master Activity Report, containsstring(Master Activity Report[Item],"Initial"))) , CountMaster Activity Report[Item]) )

 

Thanks so much for your response.