Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
RajeshTatineni
Regular Visitor

need to filter a row with slicer but not filtering

hello,

 

i have IPL data summary, where i am trying to make prediction for each team depending on their selection with applied slicers to filter(home team, away team, toss won, match winner, bat or bowl first).. now i created a measure: 

 

Total Win = count(all_season_summary[winner])... after this i tried to filter with csk from home team slicer... but it is not filtering out with csk and not counting showing diff number.
 
same way i did with another measure for total matched played by each team...with this:

Total Match played = count(all_season_summary[id]) this is filtering well...
 
thing is if i filter anything both measures giving me same number...
 
am i doing any funny mistake?
kindly advise...thnx
1 REPLY 1
PurpleGate
Resolver III
Resolver III

Hey,

 

How do you have your data? 

 

I made an example dataset using 1s and 0s

PurpleGate_0-1658841254570.png

These are the two measures. 

TotalWin = CALCULATE(SUM('Table'[MatchWinner]),ALLEXCEPT('Table','Table'[TeamName]))
 
MatchesPlayed = sum('Table'[AwayTeam])+sum('Table'[HomeTeam])
 
PurpleGate_1-1658841332390.png

 

 

PurpleGate_2-1658841342171.png

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.