Forum Discussion

anandav's avatar
anandav
Icon for Skilled Sharer rankSkilled Sharer
6 years ago
Solved

Creating table in dax based on user selected variable

Hi Experts,   I am trying to help a friend who is collected data on birds sighted in a region. Here is the sample data: Date Bird ID Count Month Region 1/01/2019 B01 1 1 A 2/01/2...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi anandav 

     

    It seems I have fixed it!!!

    please kindly use this measure based on my above post:

    Measure = var a = MAXX(FILTER(ALL('Table 2'),[Month]<MAX('Table 2'[Month])&&[Bird ID]=MAX('Table 2'[Bird ID])),[NewCount])
Return
IF([NewCount]=0,"No",IF(a=0,"New",IF(a>0,"Seen")))

anandav's avatar
anandav
Icon for Skilled Sharer rankSkilled Sharer
6 years ago

v-diye-msft,

Thank you for the pbix file. It was helpful but still my requirement is to identify the birds as seen, not seen or new in the analysis group compared to the control group.

 

I am wondering whether any way to do that?

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi anandav 

     

    It seems I have fixed it!!!

    please kindly use this measure based on my above post:

    Measure = var a = MAXX(FILTER(ALL('Table 2'),[Month]<MAX('Table 2'[Month])&&[Bird ID]=MAX('Table 2'[Bird ID])),[NewCount])
Return
IF([NewCount]=0,"No",IF(a=0,"New",IF(a>0,"Seen")))

    • anandav's avatar
      anandav
      Icon for Skilled Sharer rankSkilled Sharer
      6 years ago

      v-diye-msft,

      Thanks al ot. That is a good solution! 

      I really appreciate you taking the time to solve this for me.