Forum Discussion
Parameter in summarize
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.
Super UserHi 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.
rajendraongole1 Thanks I have already tried that but it is not working