Static Grand Total Row, requirement that the total should not change even when filtered

[Alrythmond]

Hi Everyone

I have got a table and its total, my requirement is to have a grand total from a another table, but in this case I will use a string, it works fine when selecting 2 or more values from the slicer but when I select only 1 it changes to the total of the one remaining value selected.

when I select the filters like this is shows correct output

but when I select only one value it shows wrong output

it should only display the text "This should not change" even if only one value is selected

here is my dax:

TOTAL = 
IF (
	HASONEVALUE ( 'Experiment Table'[Product] ),
	SUMX ( 'Experiment Table', [Whole] * [Per] ),
	"THIS SHOULD NOT CHANGE"
)

[d_gosbell · Accepted solution]

---

@Alrythmond wrote:

it should only display the text "This should not change" even if only one value is selected

---

Then you should not be using the HASONEVALUE() function. Try using ISINSCOPE() instead

[Alrythmond]

OH wow!, Thank you so much! I didn't notice there was a function like this, this will help me althroughout my development thank you so much!