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

[Jay2022]

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 

[Anonymous]

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.

[SamWiseOwl · Accepted solution]

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

or

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.

[Jay2022]

Excellent thank you