Solved: Counting a Enum list that results in a certain val... - Page 2

MyAndyBuck · 12-27-2019 02:05 AM

Hello. This is my first time posting.

I I have an ENUM in Column DAY that allows 1,2,3,4,5
I want to count how many times the result is a 1
I tried
COUNT(SELECT(Candidates[day], IN([Day], {“1”})))

The result was 1 and it should be many.
Can anyone help me with this?

Aleksi

Probably something like… COUNT(SELECT(Candidates[Day],AND([Day]=“1”,[Campaign]=[_THISROW].[Campaign])))

View solution in original post

Counting a Enum list that results in a certain value