Active user sales but total all user sales

[bilalkhokar73]

I have One user table tm_user that has all Salesman active and inactive , one column is there ISACTIVE information and one is trasaction table tm_sales

Every manager has salesman assigned When I see Manager wise sales in matrix report then all ok

I have DAX current month sales, last to last year current month sales, but many salesman is inactive

when I see particular manager Salesman wise sales then all inactive salesman are also showing , I need that only in matrix report total should come but when salesman wise sales come that time I need active salesman only

[parry2k · Accepted solution]

@bilalkhokar73 there is a two way you can handle this, either add a condition in your measure where salesperson[active] = 1 or filter the matrix visual where sales person active = 1

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  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.⚡