The parameter becomes blank with the Summarize function

[mh20221111]

When creating a column in a table using the Summarize function with the value selected by the user through the

SELECTEDVALUE function (parameter), the column from the SELECTEDVALUE function becomes blank. How can I ensure that the selected value are displayed?

======Dax sample========
VAR ParamValue = SELECTEDVALUE('ParameterTable'[ParameterColumn])
RETURN
SUMMARIZE(
'YourTable',
'YourTable'[GroupByColumn],
"ColumnA", ParamValue
"Amount",SUM('YourTable'[Amount]) * ParamValue
)

[v-kongfanf-msft · Accepted solution]

Hi @mh20221111 ,

Try the following to make manual changes:

Result = VAR ParamValue = 2
RETURN
SUMMARIZE(
    CALCULATETABLE(
        'YourTable',
        ALL('ParameterTable') 
    ),
    'YourTable'[GroupByColumn],
    "ColumnA", ParamValue,
    "Amount", SUM('YourTable'[Amount]) * ParamValue
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@mh20221111 

While creating a table or calculated column in Power BI, capturing slicer selections in real-time isn't feasible. Power BI constructs tables and columns before making them available on the report canvas. 

If you want to build a measure, yes it would work but you need to aggregate the SUMMARIZE table results 

SUMX (
SUMMARIZE(
'YourTable',
'YourTable'[GroupByColumn],
"ColumnA", ParamValue
"Amount",SUM('YourTable'[Amount]) * ParamValue
),
[Amount])

[mh20221111]

I understand that it is not feasible to capture slicer selections in real-time while creating a table or calculated column in Power BI.

However, I have further requirements. If there are two categories (category1 and category2) in a table, I want to highlight the largest aggregated result for each category2 when category1 and category2 are set in a matrix visual.

It would be great if Power BI had something similar to the LOD functions in Tableau. My understanding is that we might have to rely on the FILTER or SUMMARIZE functions , but ALL function does not accept calculated tables.

Are there any methods to achieve this?