Forum Discussion
Filter DAX formula
Hi
this is my table
| Hotel | Sale | Ownership | Rental duration |
| By the sea | 1 | Owned | |
| Forest | 3 | Rental | 5 months |
| Everest | 4 | Owned | |
| JTC | 5 | Rental | 10 months |
| Summer | 4 | Rental | 8 months |
| Family | 3 | Rental | 5 months |
it has relationship with below table:
| Rental duration | Length |
| 5 months | short |
| 8 months | medium |
| 10 months | long |
how to write DAX formula to calculate the sum of the sale for Owned and Rental , in which Rental only include medium and long length?
thanks
thanks.
ktt777 solution is attached.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
3 Replies
ktt777 try this DAX measure
Total Sales = CALCULATE ( SUM ( Data[Sale ] ), FILTER ( Data, Data[Ownership ] = "Owned" || RELATED ( Rental[Length] ) IN { "long", "medium" } ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
What if my data is :
Hotel Sale Ownership Rental duration By the sea 1 Owned by government Forest 3 Rental from government 5 months Everest 4 Owned by private JTC 5 Rental from partner 10 months Summer 4 Rental from private 8 months Family 3 Rental from government 5 months and it related to 2 below table :
Rental duration Length 5 months short 8 months medium 10 months long Ownership Owership Summary Owned by government Owned Rental from government Rental Owned by private Owned Rental from partner Rental Rental from private Rental Again, how to write DAX formula to calculate the sum of the sale for Owned and Rental , in which Rental only include medium and long length?
thanks
ktt777 solution is attached.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
