CALCULATE based on two criteria in another column

[StoryofData]

Hi, I need to count
IF Unique ID has "Apples" AND "Oranges" then count only "Apples"

IF Unique ID has "Apples" AND any other catergory, count as 1

I assume this is some kind of Filter Calculate combination but I cannot figure it out

Thank you for your assistance!
 

[smpa01 · Accepted solution]

@StoryofData  you can write a measure like this

Measure = 
VAR _left =
    SELECTCOLUMNS (
        FILTER ( ALL ( 'Table' ), 'Table'[UID] = MAX ( 'Table'[UID] ) ),
        "cat", 'Table'[Category] & ""
    )
VAR _filt =
    CONTAINSROW ( _left, "apple" )
VAR __count =
    IF (
        _filt = TRUE (),
        COUNTROWS (
            FILTER ( VALUES ( 'Table'[Category] ), 'Table'[Category] <> "Orange" )
        ),
        COUNTROWS ( 'Table' )
    )
RETURN
    __count

[smpa01 · Accepted solution]

I wrote as

VAR _left
and not 
VAR_left

[smpa01 · Accepted solution]

@StoryofData  you can write a measure like this

Measure = 
VAR _left =
    SELECTCOLUMNS (
        FILTER ( ALL ( 'Table' ), 'Table'[UID] = MAX ( 'Table'[UID] ) ),
        "cat", 'Table'[Category] & ""
    )
VAR _filt =
    CONTAINSROW ( _left, "apple" )
VAR __count =
    IF (
        _filt = TRUE (),
        COUNTROWS (
            FILTER ( VALUES ( 'Table'[Category] ), 'Table'[Category] <> "Orange" )
        ),
        COUNTROWS ( 'Table' )
    )
RETURN
    __count

[StoryofData]

Is it possible to convert this result to a new column rather than a count?
If I am asking too much, I apologize 

[smpa01]

@StoryofData  what is the desired output

[StoryofData]

New Column with a count of 1 or 0 like I have in my picture above
I realize that straight up count will not let me do futher analysis, I need an actual column that will show 1 or 0 depending on category

[smpa01 · Accepted solution]

try rhis

Column =
VAR _left =
    SELECTCOLUMNS (
        FILTER ( 'Table', 'Table'[UID] = EARLIER ( 'Table'[UID] ) ),
        "cat", 'Table'[Category] & ""
    )
VAR _filt =
    CONTAINSROW ( _left, "apple" )
VAR __count =
    IF (
        _filt = TRUE (),
        CALCULATE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Category] <> "Orange" ) ) ),
        CALCULATE ( COUNTROWS ( 'Table' ) )
    )
RETURN
    __count

[StoryofData]

THANK YOU SO MUCH!

[StoryofData]

thank you so much for taking the time, for some reason, VAR_left is underlining as an error... 

[smpa01 · Accepted solution]

I wrote as

VAR _left
and not 
VAR_left

[StoryofData]

Pardon, I see my error, this works! Thank you!