Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Measure B = Measure A but only value none of A's relationships

So I have a measure which calculates the sum of column 2 - column 3 subject to a filter in column 1: 

Column 1Column 2Column 3
A82
B34
C63
A45
A46
C33
B62
C65

Measure A sums the difference between columns 2 & 3 subject to filtering by A in column 1. Therefore, the measure equals the sum of column 2 - column 3 = 3 (A)

I want to create a new measure equal to the value contained in measure A but I don't want the relationship measure A contains (the filter by A). I purely only want the value (3). 

I summary,  I want to create a new measure equal to another measure but I only want its value, nothing else. 

 

Many thanks for your help

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous 
CALCULATE(
       SUMX(
                STRESS_Table, STRESS_Table[MV]) + SUMX(STATEMENT_table, STATEMENT_table[mid]),                         ALL(STRESS_Table
                   )
               )
 
or else
CALCULATE(
       SUMX(
                STRESS_Table, STRESS_Table[MV]) + SUMX(STATEMENT_table, STATEMENT_table[mid])
              )

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@Anonymous 
whatever columns impact you want to exclude from measure put that columns in all function

CALCULATE(SUMX(tbl,tbl[Column 2]-tbl[Column 3]),ALL(tbl[Column 1]))
Anonymous
Not applicable

Not sure I fully understand. Here's my measure A calculation. I need only the value from this calculation. I don't want the 0 filter included when put in measure B, only the value from measure A.
 
CALCULATE(
       SUMX(
                STRESS_Table, STRESS_Table[MV]) + SUMX(STATEMENT_table, STATEMENT_table[mid]),                         FILTER(STRESS_Table, STRESS_Table[ScenarioUnderlying] = 0
                   )
               )
 
Thank you 🙂
Anonymous
Not applicable

@Anonymous 
CALCULATE(
       SUMX(
                STRESS_Table, STRESS_Table[MV]) + SUMX(STATEMENT_table, STATEMENT_table[mid]),                         ALL(STRESS_Table
                   )
               )
 
or else
CALCULATE(
       SUMX(
                STRESS_Table, STRESS_Table[MV]) + SUMX(STATEMENT_table, STATEMENT_table[mid])
              )

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.