topic Re: Using a DAX measure in a table visualisation to return the same scalar value in a new column in DAX Commands and Tips

Using a DAX measure in a table visualisation to return the same scalar value in a new column

noneother — Tue, 21 Dec 2021 12:10:43 GMT

Hello

I want to use a DAX measure (not a calculated column) as a fourth column (outlined in red, below) within a table visualisation.

However, my DAX only returns the single row:

DAX = VAR varStatusGroup = "Final" VAR varStatus = "Disposed" RETURN CALCULATE ( MIN('Status'[Status]) ,KEEPFILTERS('Status'[Status group] = varStatusGroup) ,KEEPFILTERS('Status'[Status] = varStatus) )

What am I doing wrong?

I want:

Data model:

Re: Using a DAX measure in a table visualisation to return the same scalar value in a new column

smpa01 — Tue, 21 Dec 2021 12:26:13 GMT

noneother does this work?

CALCULATE ( MIN('Status'[Status]) ,'Status'[Status group] = "Final" ,'Status'[Status] = "Disposed" )

Re: Using a DAX measure in a table visualisation to return the same scalar value in a new column

noneother — Tue, 21 Dec 2021 12:37:12 GMT

That works but I introduces redundant rows, creating way more than the original 5 rows for Type ID: AEG3ML

Re: Using a DAX measure in a table visualisation to return the same scalar value in a new column

smpa01 — Tue, 21 Dec 2021 12:50:29 GMT

noneother is it kindly possible to provide a sample pbix please?

Re: Using a DAX measure in a table visualisation to return the same scalar value in a new column

VahidDM — Tue, 21 Dec 2021 23:03:49 GMT

Hi noneother

Based on your post and dax you shared, you want to show "Disposed" in the fourth column, so if I got it correctly, try this:

DAX = "Disposed"

Otherwise, can you please add more details?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/