Forum Discussion
n25philly
2 years agoNew Member
Need help filtering data
Just started with BI and it seems like you need to be a programmer to actually use this which is annoying. I need help filtering data on a chart I am creating. I'm using a stacked column chart. ...
n25philly
2 years agoNew Member
I'm sorry, very new to this, what do you mean by measure and where would I write it?
- Daniel291952 years agoCommunity ChampionMeasure 4 = sum(Calendario[Día])
Calendario : this is the table name
Día : this is the column name .
sum(Calendario[Día]) will return the sum of values in the column of that table .now back to your requirement ,measure =if( sum( table_name[col_name]) = 0 , blank() , sum( table_name[col_name]) )table_name -> change it to the table name you have.col_name --> change ie to the column name you want to add its vaulues.If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠