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

Stachu's avatar
Stachu
Community Champion
7 years ago

what's the syntax for [Ind]?

  • 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