Forum Discussion
Post PartisanNeed help creating additional rows in matrix table that fall under two criteria
Hi julesdude ,
I'm sorry but I'm not sure I fully understand what you are saying, it might be easier for me to understand your needs if you could attach a picture of what you want the intended effect to be.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Post PartisanHi Anonymous
Thanks for responding. I think the best way to tackle this is to create a DAX column or measure (whichever makes more sense) with the following logic:
1. Take the Asset Reference
2. Take the Unit Reference
3. Filter by Asset Reference and Unit Reference so that it matches the same Asset Reference and Unit Reference for that row, and filter Unit Ended column by False results
4. For the above filtered results, count number of 'True' results from column [Lease Ended]
5. Return count number
This way if there is a count number greater than 0 we know that for this asset's unit number, the unit is not ended, and we have a Lease Ended = True (a end lease date or terminated lease date is in the past relative to today's date).
How do I achieve this in DAX?