Forum Discussion
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. ...
I'm sorry, very new to this, what do you mean by measure and where would I write it?
Measure 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! 🤠
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠