Forum Discussion

newbie_powerbi's avatar
newbie_powerbi
Icon for Helper II rankHelper II
3 years ago

andhiii079845 

sure, you have incorporated the logic of open inside the measure but my logic has mutiple conditions for open & my table has 10 millions rows

 

I just added a simple logic for the understanding

I need the same results using open ticket count measure

 

thank you

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Than change it like this:

Measure 2 =
MAXX(FILTER('Table','Table'[open ticket count]=1),'Table'[open_dt])
 
  • newbie_powerbi's avatar
    newbie_powerbi
    Icon for Helper II rankHelper II
    3 years ago

    ss

    placed the measure but it is returning the same value as open_dt

    • andhiii079845's avatar
      andhiii079845
      Icon for Solution Sage rankSolution Sage
      3 years ago

      You can not but open_dt and close_dt in this matrix. look to my matrix.

      • andhiii079845's avatar
        andhiii079845
        Icon for Solution Sage rankSolution Sage
        3 years ago

        Make a matrix in excel and show us what you want to see 1:1 🙂

    • andhiii079845's avatar
      andhiii079845
      Icon for Solution Sage rankSolution Sage
      3 years ago

      You mentionied this, what you want zu see (yellow):

       

      I send you this: (measure definition in my previous post)

       

      You build this: 

      Delete the columns open_dt and close_dt in your matrix. 🙂
      Than you get the yellow marked rows. If you want something else please make a little example in excel what do you want to see excatly.