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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors