Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter on FIRSTNONBLANK

Hi,   I want to calculate something and filter on a string value in a DAX formula. In my slicer I select some string values and I want to calculate the value of the first string value.   But thi...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    hI Anonymous

     

    Try this

     

    Measure =
VAR MYVALUE =
    FIRSTNONBLANK ( 'Table'[StringColumn], 0 )
RETURN
    CALCULATE ( SUM ( 'Table'[value] ), 'Table'[StringColumn] = myvalue )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

hI Anonymous

 

Try this

 

Measure =
VAR MYVALUE =
    FIRSTNONBLANK ( 'Table'[StringColumn], 0 )
RETURN
    CALCULATE ( SUM ( 'Table'[value] ), 'Table'[StringColumn] = myvalue )