Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
7 years ago
Solved

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

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...
Need Help
Tips and Tricks
  • SivaMani's avatar
    SivaMani
    7 years ago

    v-yulgu-msft,

     

    I tried this. But it's not working.

     

    I have achieved this using bookmarks.

     

    Thanks,

    Siva

SivaMani's avatar
SivaMani
Resident Rockstar
7 years ago

It's just a number in a table,

 

NameInd
TA0
FA1
RA2
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi SivaMani,

 

Please try this:

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

 

Best regards,

Yuliana Gu

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    7 years ago

    v-yulgu-msft,

     

    I tried this. But it's not working.

     

    I have achieved this using bookmarks.

     

    Thanks,

    Siva

    • Muratik55's avatar
      Muratik55
      Helper I
      3 years ago

      how did you use bookmarks?