Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Parameter in summarize

Value which is in the Threshold variable is not getting passed. Kindly help me on this...   Filtered_Customs_Data_Input = VAR Threshold = [Parameter Value]--500  -- Replace with your parameter or...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,
    Thank you for reaching out to us on Microsoft Fabric Community Forum. Also  thanks Nasif_Azam and rajendraongole1 for the helpful insights!

    I tried to recreate it on my local upon my understanding.Please refer the screenshot and file for your reference.


    If this answer meets your requirement,give us kudos and consider accepting it as solution.If still require further assistance, feel free to reachout!

    Regards,
    Pallavi G.

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi Anonymous  - create a measure for selected value as below:

 

SelectedThreshold = SELECTEDVALUE(ThresholdParameter[Value], 500)

 

Now , create a measure now:

Filtered_Customs_Data_Input =
VAR Threshold = [SelectedThreshold] -- this should be a scalar measure
VAR FilteredIdentifiers =
SUMMARIZE(
FILTER(
ADDCOLUMNS(
SUMMARIZE('CBAM_Goods_InScope', [EntryIdentifier]),
"TotalCustomsValue", CALCULATE(SUM('CBAM_Goods_InScope'[CustomsValue]))
),
[TotalCustomsValue] > Threshold
),
[EntryIdentifier]
)
RETURN
FILTER(
'CBAM_Goods_InScope',
'CBAM_Goods_InScope'[EntryIdentifier] IN SELECTCOLUMNS(FilteredIdentifiers, "EntryIdentifier", [EntryIdentifier])
)

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    rajendraongole1 Thanks I have already tried that but it is not working 

     

    Filtered_Customs_Data_Input =
    VAR Threshold = [Parameter Value]

    /*SELECTEDVALUE('Parameter'[Parameter], 500)--[Parameter Value]--500  -- Replace with your parameter or use a disconnected table parameter*/
    VAR FilteredIdentifiers =
        SUMMARIZE(
            FILTER(
                ADDCOLUMNS(
                    SUMMARIZE('CBAM_Goods_InScope', [EntryIdentifier]),
                    "TotalCustomsValue", CALCULATE(SUM('CBAM_Goods_InScope'[CustomsValue]))
                ),
                [TotalCustomsValue] > Threshold
            ),
            [EntryIdentifier]
        )
    RETURN
        FILTER(
            'CBAM_Goods_InScope',
            'CBAM_Goods_InScope'[EntryIdentifier] IN SELECTCOLUMNS(FilteredIdentifiers, "EntryIdentifier", [EntryIdentifier])
        )