Forum Discussion

mariaSam1014's avatar
mariaSam1014
Helper I
2 years ago

COUNT based on categorized criteria(priority basis)

HI Power community, This is my first post ever:   Tenant OccupierId Location Weekly _RN RISK Severity Level RN_delta Severity Trend ABC 11 BAC drive Bathroom 1 237.33 EXTREME 237....
Need Help
Gabry's avatar
Gabry
Super User
2 years ago

I think you can try with this

calculate(distintcount (occupierID), allexcept(table, risk severity,severity trend)

let me know

  • mariaSam1014's avatar
    mariaSam1014
    Helper I
    2 years ago

    Hey Gabri,
    This was the first ever solution  I tried but its giving totally wrong results. (counting everything in every criteria)

    • Gabry's avatar
      Gabry
      Super User
      2 years ago

      Sounds really strange, could you paste your table not as an image? So I can copy paste

      • mariaSam1014's avatar
        mariaSam1014
        Helper I
        2 years ago

        i have edited the orignal post please check