Forum Discussion
Is this a bug or something? (Using IF, HASONEVALUE and BLANK functions)
I have a measure formula like this: IF(HASONEVALUE([column_name]) , SUM([other_column_name]) , BLANK() ), so it should give the sum of the other column when the current context is one row and give blank when the current context includes more than one row.
Though, when I add this measure to a visual, it doesn't allow me to include this measure in values. If I change "BLANK()" for 0 or 1, it plots the measure values without any problem. Why could this happen?
2 Replies
- amitchandak
Super User
Anonymous , I am hopinh you are plotting it with column/axis/row of column_name .
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Also refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
I can't share. I am plotting a Clustered column chart with a column of the same table (with repeated values) in the Axis well and the wanted measure in the Values well. When I set the measure value to SUM([other_column_name] or 0, then it plots a column for every axis value, including those who are zero (and I actually don't want those to be showed); and when I set the measure value to SUM([other_column_name] or BLANK(), the chart doesn't support it. Why?
