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. 

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
2 years ago

Hi, i was checking your project, you need to remodel it, you are changing the filter but you're still seing the same thing.
But now asking your question, your problem its because the 'Master Lookup table' its not related with 'Date Table',  so to be able to filter values using date your need to relate these tables mentioned above.
Look the experiment bellow, when you click into matrix the controws its working normally.