Forum Discussion
Solved
Text based filtering.
Hello All, I have a table like this, Index Product Value 1 Bike Green 2 Bike Yellow 3 Bike Green 4 Bike Green 5 Bike Red 6 Clothing Red 7 Clothing Green ...
NithinBN
Can you check this measure:Measure = VAR Green = CALCULATE( COUNTROWS(Table1), Table1[Value]= "Green" ) VAR YellowRed = CALCULATE( COUNTROWS(Table1), Table1[Value] = "Yellow" || Table1[Value] = "Red" ) RETURN DIVIDE( Green, YellowRed )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
