Forum Discussion

larrylob's avatar
larrylob
Regular Visitor
5 years ago
Solved

Count if a rows range falls within another range

Hello,   I have looked around and have not found an answer to my problem and hope someone could help me.   Right now i have a few different tables from different entities that have constraints th...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    You can add a calculated column to your Sections table like this:

    # Constraints =
VAR SectionStart = Sections[Mile Start]
VAR SectionEnd = Sections[Mile End]
RETURN
    COUNTROWS (
        FILTER (
            Constraints,
            Constraints[Mile Start] < SectionEnd &&
            Constraints[Mile End] > SectionStart
        )
    )

     

AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

I was not suggesting a custom column in the query editor but rather a calculated column in DAX.

 

You'd need to adjust it a bit to use it as a measure instead of a calculated column (e.g. use MIN/MAX aggregations on Sections[Mile Start]/Sections[Mile End]).

larrylob's avatar
larrylob
Regular Visitor
5 years ago

Thanks! It worked. I'm wondering now is there a way to link the column to the data so that when you show the data as a table you can pull the actual information from the source that the column is counting? 

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    5 years ago

    That would warrant a separate question, I think.