6 Replies Latest reply on Dec 3, 2018 3:47 AM by Ombir Rathee

    Find count in blended source

    Alexander Mik

      Hi,

       

      I have 2 graphs; one where it show revenu over years and one graph where it shows revenu based on a detailed number. This number is only relevant when 1 product is selected. So it should show 1 graph when nothing is selected and the other when a selection in products is made. This worked, but now I have a blended source where my product master list comes from and because of the blend my previous formula isn't working any more. I have no other option then to use the blend unfortunately.

       

      this was my previous formula:

      IF

      TOTAL( COUNTD( [Book Serie] ) ) = SUM( { FIXED : COUNTD( [Book Serie] )})

      THEN

      null

      ELSE

      sum([Rev Books BL])

      END

       

      That Book Serie field is now in the blended source and the revenue field is in the primary source.

      Hope you guys can help me!

       

      Best regards,

      Paul