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

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.