Use Measure as a filter and use measure in if statement

[Anno2019]

Hi Guru's

Having some trouble with what seems to be an easy problem.  Multiple posts on this subject but does not match my problem completely, as my measures return text results.

PBIX file shared in below link.

https://www.dropbox.com/s/3hlfqjrgx600b7a/Measure%20as%20filter%20and%20calculate%20if%20on%20measur...

1.   I need to use [Multiple Fruits] as a filter, there are two results "More than One" & "Only One", User needs to be able to choose 1 or both, and the list should show all rows where either "More than One" is selected or "Only One" is selected or Both.

2.  [5.Red More than One Sales] = If [Customer Type] = "RED" and [Multiple Fruits] = "More than One" then [Total Sales Sum]

3.  [5.Red Only One Sales] = If [Customer Type] = "RED" and [Multiple Fruits] = "Only One" then [Total Sales Sum]

[Jihwan_Kim]

Hi,

I am not sure if I understood your data model correctly, but your measure [Multiple Fruits] and calculated column Table[Multiple Fruits DIM] are different. If using the measure [Multiple Fruits] is correct, please check the below measures and the attached pbix file.

5.Red More than One Sales =
CALCULATE (
    [Total Sales Sum],
    FILTER (
        'Table',
        'Table'[Customer Type] = "Red"
            && [Multiple Fruits] = "More than One"
    )
)

[Anno2019]

@Jihwan_Kim 

Thank you! Points 2 & 3 work as per your guidance.

The [Multiple Fruits DIM] was my lame attempt to try to use it as a filter but it does not work.

Would you have any guidance on how I could use [Multiple Fruits] results as a filter?  Not the [Multiple Fruits DIM]

[Jihwan_Kim]

Hi,

You can create a calculate column.

I tried to create it, however, it is quite difficult for me to understand the logic how you create measures especially percentage measures, and it is not easy for me to create a calculated column without understanding a logic that you applied for all your measures.

Thanks.