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.

vojtechsima's avatar
vojtechsima
Super User
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
    Not applicable
    1 year ago

    Thanks for this formula!
    Seems I'm facing another issue here, because my report has another filters by report level to excluded no current rows  like [customer actives], [Agent Name], [customer excluded] are the main ones. I tried to use ALLEXCEPT but doesn't seem to work because the ouput it's like a bigger number that the expected one.

    • 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!