topic Re: how do i get a value from a calculation to show the same value all the way down a column in a table in DAX Commands and Tips

how do i get a value from a calculation to show the same value all the way down a column in a table

Jay2022 — Tue, 29 Oct 2024 13:27:41 GMT

so i made a new measure which resulted in a value i now want that value to appear all the way down a colum so that i can pull other fields in to create a table and also perform calculations from other columns with the valye created in the measure

Re: how do i get a value from a calculation to show the same value all the way down a column in a table

SamWiseOwl — Tue, 29 Oct 2024 13:34:02 GMT

Hi Jay2022
Is this a calculated column (back end in the data table) or a measure (in a visual).

If it is a measure in a visual then you can use:
Calculate( [Your Measure], table[Column] = "Your filters") to add filters

Calculate( [Your Measure], all(table), All(table[Column])) to remove certain filters on tables or columns.

If it is a calculated column, you can create the column and set it equal to your measure.

Re: how do i get a value from a calculation to show the same value all the way down a column in a table

Anonymous — Wed, 30 Oct 2024 02:54:43 GMT

Hi Jay2022

This may help:

Here I create a set of sample:

Table:

Then add a measure:

Measure = SUM('Table'[Values])

If I want the value of the measure shows grouped by ID, it's possible to add a filter in the measure:

MEASURE = VAR _currentID = SELECTEDVALUE ( 'Table'[ID] ) RETURN CALCULATE ( SUM ( 'Table'[Values] ), FILTER ( ALL ( 'Table' ), 'Table'[ID] = _currentID ) )

The result is as follow:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Understand the Filter Context and How to Control i... - Microsoft Fabric Community

Best Regards

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

Re: how do i get a value from a calculation to show the same value all the way down a column in a table

Jay2022 — Wed, 30 Oct 2024 09:47:32 GMT

Excellent thank you