Forum Discussion

Z4m's avatar
Z4m
Frequent Visitor
10 years ago
Solved

Calucaltion on Filtered set op Rows when Value is containing in A collumn

Hello Guys, I am trying to get a measure (of calculated collumn) in my Power BI that returns a SUM of a specific value. To be more specific;   The table i have is; Empl  | Month | Value | Year...
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    Z4m

     

    In this scenario, you can create two measures with following formulas to get the results.

    Measure Result = 
IF ( SUM ( Table1[Value] ) < COUNTROWS ( Table1 ), 0, 1 )
    Measure Total = 
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Empl],
        Table1[Month],
        Table1[Year],
        "Measure Result", [Measure Result]
    ),
    [Measure Result]
)

     

    Best Regards,

    Herbert

     

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

Z4m

 

In this scenario, you can create two measures with following formulas to get the results.

Measure Result = 
IF ( SUM ( Table1[Value] ) < COUNTROWS ( Table1 ), 0, 1 )
Measure Total = 
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Empl],
        Table1[Month],
        Table1[Year],
        "Measure Result", [Measure Result]
    ),
    [Measure Result]
)

 

Best Regards,

Herbert