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
        )
    )

     

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
Icon for Super User rankSuper User
5 years ago

That would warrant a separate question, I think.