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 |
| 8 | Clothing | Red |
| 9 | Clothing | Yellow |
| 10 | Clothing | Red |
| 11 | Accessories | Green |
| 12 | Accessories | Red |
| 13 | Accessories | Green |
| 14 | Accessories | Yellow |
| 15 | Accessories | Green |
I want to create a measure which count all the Green for product "Bike".
At last I want to have a bar chart, where axis is Product and value is Divide("Number of Green"/("Number of Yellow"+"Number of Red"))
Thanks in advance.
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 🙂
3 Replies
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 🙂
