DAX Measure

[rasheedbisuga79]

I'm having issues in using DAX formula to craete a column for the details below from a related column

1. A range of diamters like  0-50, 50- 100, 100-- 50 and larger than 50

2. Age range like 0-20, 20-40, 40-60 and older than 60

[Anonymous · Accepted solution]

Hi @rasheedbisuga79 ,
Thanks to @Greg_Deckler  reply.
Here is a measure you can try to change the range to filter the data
Sample data

Create a measure

Measure = 
CALCULATE(
    MAX('Table'[Value]),
    FILTER(
        'Table',
        SELECTEDVALUE('Table'[Diamters]) >=0 && SELECTEDVALUE('Table'[Diamters]) <=50
    )
)

Final output

If you want to change the range or add another filter, you can change the conditions in the if function.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Greg_Deckler]

@rasheedbisuga79 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.