Forum Discussion

Tober1996's avatar
Tober1996
Helper I
4 years ago
Solved

Easy formula for multiple countrows filter

Hello, I tried to find a solution for the following question in the community, but I can't transfer the shown solutions (Please be lenient with a beginner...). I hope there are users here who solve this in seconds:

 

This measure is ok:

1User = COUNTROWS(FILTER(Rawdata,[NumberOfUser] = 1))

 

The measure should be expanded like this:

1User = COUNTROWS(FILTER(Rawdata,[ NumberOfUser] = 1  or Table „Rawdata" Row "Workshop“ is not empty))

 

Thanks for help!

2 Replies

  • Tober1996 ,

    1User = COUNTROWS(FILTER(Rawdata,[ NumberOfUser] = 1 && not(isblank(Rawdata[Workshop])) ))

    • Tober1996's avatar
      Tober1996
      Helper I

      Dear amitchandak,

      this community is great! 1000 times thanks for the quick reply