Forum Discussion
Filter DAX formula
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.⚡
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.⚡