Forum Discussion

jalaomar's avatar
jalaomar
Helper IV
6 years ago

Count distinct rows after a certain date

Hi all!

 

I would like to get help on creating a new measure that count distinct rows after a specific date.

In a column I have the so called "CI Status" - For the CI status related to the following

"W/ Released Solution"

"W/ Sustainable Containment"

"W/ Impl. Permanent Sol."

 

I would like to count if there are any new technical issues (TI) linked after its Date: CI Closed

 

Any suggestions of how a DAX measure could look like for thid scenario?

 

Best regards,

J

 

3 Replies

  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    I think you will have to post some sample data for us to understand what you're trying to do, instead of just column names or values.

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    jalaomar ,

     

    Your requirement is not clear. Please show sample data and expected result.

     

    Regards,

    Jimmy Tao

    • jalaomar's avatar
      jalaomar
      Helper IV
      6 years ago

      Hi,

      Currently am working with Cost Poor Quality data and further would like to highlight all Technical issues (TI) and related cost that has been linked to a Consolidated Issue (CI) after its Date: CI Closed.

      Example: If a CI was closed on date 2019-01-01 with a solution then I would like to monitor if new Technical Issues was logged after that date and its related cost.

      Date: CI Closed

      2019-01-01

      2018-06-30

      2017-04-05

      ....

      The Column Date: CI Closed has different dates depending when a solution was in place. I would to monitor all new Technicla issues  and related Cost logged after thoses dates. a technical issue has a occurrence date.

      so the Occurence date should always be after the Date: CI Closed.

       

      is it possible to display values only after Date: CI Closed?

       

      Best regards,

      Jala