Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter a table based on a measure value

Hello,   I have  two tables and two cards here.        (I want to remove the total row in the second table how do I do that?) Now I am trying to create additional table that are consist ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , one way is is use visual level filter , measure is not blank.

     

    Or have meausre like the example

    sumx(filter(values(Table[end]), not(isblank([measure]))),[measure])

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , one way is is use visual level filter , measure is not blank.

 

Or have meausre like the example

sumx(filter(values(Table[end]), not(isblank([measure]))),[measure])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you again Amitchandak ğŸ™‚