Navigation

    Communauté Digdash

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    UNSOLVED Measure

    Studio
    2
    3
    245
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      Madeleine last edited by

      Hi,

      I would like to create a calculated measure with the following criteria:

      Aggregation: Dcount
      Dimension: ID

      Condition: (v)

      if(v > 0) {
      return true;
      } else {
      return false;
      }

      The issue is that in the filed "Measure" only the measures from the data source are visible.

      9efbdac9-4771-430c-abda-c29a64443577-image.png

      Please advice.

      GregoryBiraud 1 Reply Last reply Reply Quote 0
      • GregoryBiraud
        GregoryBiraud Expert DigDash @Madeleine last edited by

        Hi @madeleine ,

        You can only use here measures from the datasource or measure calculated before aggregation.
        What you are trying to do here is to count distinct ID line by line where global "Total annuel" is greater than 0.

        Grégory Biraud

        Grégory Biraud

        M 1 Reply Last reply Reply Quote 0
        • M
          Madeleine @GregoryBiraud last edited by

          @gregorybiraud

          Hi,

          you are right, sorry my mistake.

          Merci.

          1 Reply Last reply Reply Quote 0
          • 1 / 1
          • First post
            Last post
          • Accueil
          • Webinaires
          • Documentation
          • Interviews
          • Vidéos tutos