Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago
Solved

Correct Row Count ( Example file attached)

I have a table visual that is made up of various columns (measures) and there is also a visual filter...   Closed before = Sumx(values('Master Lookup Table'[Buidling Code]), IF([Location Stat...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi StuartSmith ,

     

    Please update your measure.

    Count Rows = 
VAR AllRows = COUNTROWS(FILTER(ALLSELECTED('Master Lookup Table'),[Closed before]=0))
Return
AllRows

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago

Unsure how I can change the report so it filters "Archvied" sites that are closed before the date slicer selection without using...

 

Closed before =
Sumx(values('Master Lookup Table'[Buidling Code]),
IF([Location Status] = "Archived" && [Date Closed] < [1) First Period Date] , 1,
0))