DAX Formula for 10 or 10% of a number

[barragan82]

Hi everyone. I am hoping to create a measure that will automatically populate either the number 10 if a number is less than or equal to109, or automatically populate 10% of a number if the number is greater than or equal to 110. 

In the sample below, this measure would be applied according to the number in the Assignments column. Course A has 110 assignments, so the measure would automatically populate the number 11 because the number of assignments is greater than or equal to 110, and 11 is 10% of 110. Course B has 86 assignments, so the measure would automatically populate the number 10 because 86 is less than or equal to 109. Course C would be populated with 23 because 236 is greater than 110, and 23 is 10% of 236, and Course D with 10 because 26 is less than 109. I would greatly appreaciate any help. Thank you!

[Aburar_123 · Accepted solution]

Hi @barragan82 ,

You can write a measure like below,

Measure = if(MAX('Table'[Assignments])<=109,10,FORMAT((MAX('Table'[Assignments])*.10)/100,"##%"))

if you dont want the %symbol, just correct the measure as below,

Measure = if(MAX('Table'[Assignments])<=109,10,MAX('Table'[Assignments])*.10)

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

expected result measure: =
VAR _assignment =
    SELECTEDVALUE ( data[assignments] )
RETURN
    IF (
        HASONEVALUE ( data[course] ),
        SWITCH (
            TRUE (),
            _assignment < 110, 10,
            _assignment >= 110, ROUNDDOWN ( _assignment * 0.1, 0 )
        )
    )

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

expected result measure: =
VAR _assignment =
    SELECTEDVALUE ( data[assignments] )
RETURN
    IF (
        HASONEVALUE ( data[course] ),
        SWITCH (
            TRUE (),
            _assignment < 110, 10,
            _assignment >= 110, ROUNDDOWN ( _assignment * 0.1, 0 )
        )
    )

[barragan82]

This works great, thank you!

[Aburar_123 · Accepted solution]

Hi @barragan82 ,

You can write a measure like below,

Measure = if(MAX('Table'[Assignments])<=109,10,FORMAT((MAX('Table'[Assignments])*.10)/100,"##%"))

if you dont want the %symbol, just correct the measure as below,

Measure = if(MAX('Table'[Assignments])<=109,10,MAX('Table'[Assignments])*.10)

[barragan82 · Accepted solution]

This works exactly as I need it to. Thank you!!