Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Maximum of Count

Hello, I am new to power bi. I am facing a problem. I want to cre ate a new column as "Highest Target Quantity" which shows for Jan 1st Highest Target Quantity achieved as 2 and for Jan 2 Highest ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    One sample for your reference. Here we can create two measures as below to get the result as we need.

     

    MAX = CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[DATE]),VALUES(Table1[ITEM]))
    MAXX = MAXX(Table1,[MAX])

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    To create another new measure and make the table visual filterd by the measure.

     

    Measure = var result = MAXX(ALLEXCEPT(Table1,Table1[DATE]),[MAXX])
return
IF([MAX]=result,1,0)

     

    Regards,

    Frank

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
7 years ago

Anonymous

 

Do you want to create a measure or column?

 

If you want to create a measure

 

maxcount = MAX(Table5[count])

 

 

if you want to create a column

 

maxcount2 = MAXX(FILTER(Table5,'Table5'[date]=EARLIER(Table5[date])),Table5[count])

 

 

 

1

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Ryan, 

Thank you for your time to reply to my issue. I would like to know how you created the "count" column? It looks like a summarized table ,compared to my Count column which has only "1" in all the row values.

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    7 years ago

    Anonymous

     

    I just create a new column. I also attached the DAX. You can have a try on your end. Thnaks

     

    maxcount2 = MAXX(FILTER(Table5,'Table5'[date]=EARLIER(Table5[date])),Table5[count])