Forum Discussion

Julia2023's avatar
Julia2023
Helper I
1 year ago

Goal Type Measure

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")

 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    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.