Forum Discussion
IF Statement error
Replace [category] with selectedvalue(tablename[category]). but the total won't work here. I am not sure how you are going about this, but you may benefit from this video https://www.youtube.com/watch?v=ojHZkWkEY7Q/
As an aside, you should always add the table name before the column name (although this is not the issue causing the problem). https://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/
Replace [category] with selectedvalue(tablename[category]). but the total won't work here. I am not sure how you are going about this, but you may benefit from this video https://www.youtube.com/watch?v=ojHZkWkEY7Q/
As an aside, you should always add the table name before the column name (although this is not the issue causing the problem). https://exceleratorbi.com.au/best-practices-power-pivot-power-query-power-bi/
Thank you very much, Matt!
