Forum Discussion

SEunson's avatar
SEunson
Frequent Visitor
4 years ago
Solved

View rows counted in CountX function

Hi all, I have a measure which counts the number or rows in a table, depending on a condition e.g. COUNTX(     TableA,      IF(         AND(             TableA[Start Date] <= [Month End],      ...
DAX
Iterator
  • johnt75's avatar
    johnt75
    4 years ago

    Create a new measure like 

    Is Visible = IF( 
SELECTEDVALUE('TableA'[Start Date]) <= [Month End] &&
( SELECTEDVALUE('TableA'[End Date]) >= [Month Start] || ISBLANK(SELECTEDVALUE('TableA'[End Date])),
1)

    then use that as a filter on your table visual to only show rows when the value is 1

johnt75's avatar
johnt75
Super User
4 years ago

Create a new measure like 

Is Visible = IF( 
SELECTEDVALUE('TableA'[Start Date]) <= [Month End] &&
( SELECTEDVALUE('TableA'[End Date]) >= [Month Start] || ISBLANK(SELECTEDVALUE('TableA'[End Date])),
1)

then use that as a filter on your table visual to only show rows when the value is 1