Forum Discussion

ooctaviano's avatar
ooctaviano
Frequent Visitor
5 years ago
Solved

Filter no working on measure

I have two measures using two tables, both tables have a salesperson number Sales for month Budget for month   Both are conected to a salesperson table which has the sales person number   The...
  • parry2k's avatar
    5 years ago

    ooctaviano that is a different issue, there are few ways to do this. You can use visual level filter on the slicer to say where sales measure is not blank or you change the cross filter direction to both between salesperson and sales table (it is not recommended) but visual level filter is the way to go.

     

    Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.