Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DAX Measure Ignoring one specific

Hey community! I've been struggling with a measure that in theory shoulnd't be a problem.  I have a measure called "DM Sold Hours" that I use for a table with data by Area and I want another one th...
Need Help
Tutorial Requests
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hi, Anonymous 
    try this measure:

    New Output = 
var currrentZone = SELECTEDVALUE('Table'[Zone])
var _sum = SUMX(FILTER(ALL('Table'), 'Table'[Zone] = currrentZone), 'Table'[DM Sold Hours])

return _sum

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    According to your statement, I think your issue is that you want to keep filter in your measure. 

    I think you can try ALLSELECTED() FUNCTION.

    New Output =
VAR currrentZone =
    MAX ( 'Table'[Zone] )
VAR _sum =
    SUMX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Zone] = currrentZone ),
        'Table'[DM Sold Hours]
    )
RETURN
    _sum

     

    Best Regards,
    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

According to your statement, I think your issue is that you want to keep filter in your measure. 

I think you can try ALLSELECTED() FUNCTION.

New Output =
VAR currrentZone =
    MAX ( 'Table'[Zone] )
VAR _sum =
    SUMX (
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Zone] = currrentZone ),
        'Table'[DM Sold Hours]
    )
RETURN
    _sum

 

Best Regards,
Rico Zhou

 

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you!
The value was a little bit different but adjusted with CALCULATE and using ALLSELECTED did the trick!