Goal Type Measure

[Julia2023]

Hi, can anyone suggest a workaround for creating the Product ID type? Currently, I'm using this measure, but adding all Product IDs has exceeded the resource limits, and no results are generated. I’d really appreciate any help!

Goal Type = 
 VAR _PROPORTION = [Position]
VAR _P2 = 
    CALCULATE(
        [Position],
        FILTER(
            ALL('ID'[Product ID]),
            [Position] >= _PROPORTION
        )
    )
RETURN 
    IF(_P2 <= 0.8, "I", "II")

[Ashish_Mathur]

Hi,

Explain the question in simple language.  Share some data to work with and show the expected result.  Share the download link of the PBI file.