Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Tober1996
Helper I
Helper I

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!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Tober1996 ,

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Tober1996 ,

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

Dear amitchandak,

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.