calculate value based on another column set of values

[benqpbi]

i have calculated my percentage by using this calculation 

Measure = DIVIDE(CALCULATE(SUM('Table Name'[comp_record])),CALCULATE(SUM('Table Name'[comp_record]),ALL('Table Name'))

now i have a column named level which has many values but i want to only calculate the above measure for level 4,5,6 only else blank 

[danextian]

Hi @benqpbi 

The measures below change the filter context in your denominator

=
//shows the value each for 4 or 5 or 6

CALCULATE (
        SUM ( 'Table Name'[comp_record] ),
        FILTER ( 'Table Name', 'Table Name'[Level] IN { 4, 5, 6 } )
    )

=
//shows the total value 4, 5 and 6 regardless of filter applied to table 'Table Name'[Level]

CALCULATE (
        SUM ( 'Table Name'[comp_record] ),
        FILTER ( ALL ( 'Table Name'[Level] ), 'Table Name'[Level] IN { 4, 5, 6 } )
    )

=
//shows the total value 4, 5 and 6 regardless of filter applied to table 'Table Name'

CALCULATE (
        SUM ( 'Table Name'[comp_record] ),
        FILTER ( ALL ( 'Table Name' ), 'Table Name'[Level] IN { 4, 5, 6 } )
    )

[benqpbi]

hello, thank you

i have a doubt how it would calculate the percentage because i need to first calculate the percentage by using this 

Measure = DIVIDE(CALCULATE(SUM('Table Name'[comp_record])),CALCULATE(SUM('Table Name'[comp_record]),ALL('Table Name')) 

then ony calculate the percentage only for level 3,4,5

[danextian]

Hello, my suggestions were only for the denominator which is the second argument in your divide formula. Alternatively, you can modify your formula to show the value only if it meets a certain condition

=
IF (
    SELECTEDVALUE ( 'Table Name'[Level] ) IN { 4, 5, 6 },
    DIVIDE (
        SUM ( 'Table Name'[comp_record] ),
        CALCULATE ( SUM ( 'Table Name'[comp_record] ), ALL ( 'Table Name' ) )
    )
)

Answers provided are based on the information provided. You can provide more details - sample data and expected result https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3175712#M1071...