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. 

  • a3810's avatar
    a3810
    New Member
    2 years ago

    And when I try:

     

    Measure 2 = Divide(

    Calculate( Sum('Master Activity Report'[Item]), filter('Master Activity Report', containsstring('Master Activity Report'[Item],"Initial"))) , Sum('Master Activity Report'[Item]) )
     
    It gives a red error over "Initial"
     
    The word initial is part of the code description. Should it start with an * as it is a partial match?
     
    Thanks again.