DirectQuery: Data source has exceeded the maximum allowed size of '1000000' rows

[SivaMani]

Hi,

I have two measures,

Functional Amt - SUM(FA),

Transactional Amt = SUM(TA)

It works fine when I use these measures directly in visuals. However, it isn't working when I use the below measure,

IF(Ind =0, Functional Amt,Transactional Amt)

Getting Error Message:
The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows

Kindly assist me.

[Stachu]

what's the syntax for [Ind]?

[SivaMani]

It's just a number in a table,

Name	Ind
TA	0
FA	1
RA	2

[v-yulgu-msft]

Hi @SivaMani,

Please try this:

Measure =
IF ( SELECTEDVALUE ( Table[Ind] ) = 0, [Functional Amt], [Transactional Amt] )

Best regards,

Yuliana Gu

[SivaMani · Accepted solution]

@v-yulgu-msft,

I tried this. But it's not working.

I have achieved this using bookmarks.

Thanks,

Siva