Forum Discussion
Filter the value from another table that cannot create relationship
Roy_W your original question was to show open and that's why. It is better to be specific. Anyhow, you can remove this open condition from the measure and then add a slicer and user can choose whatever they want
hours sum = CALCULATE ( SUM ( 'from_id history'[hours] ), CROSSFILTER ( 'from_id relationship'[from_id], 'from_id data'[from_id], Both ) )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.⚡
Roy_W here is the measure and use this in the visual:
hours sum =
CALCULATE (
SUM ( 'from_id history'[hours] ),
CROSSFILTER ( 'from_id relationship'[from_id], 'from_id data'[from_id], Both ),
'to_id data'[status] = "Open"
)
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.⚡
