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. 

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Hi StuartSmith ,

referring to your original question: To count the rows in the visual you will have to create a measure - using ADDCOLUMNS(SUMMARIZE(   - to create a virtual tablewhich is the same as the visual table and then count the rows of that table.

All the same fields from the visual will have to be included in the virtual table and then the correct filtering applied to mimic the table visual.

I advise testing with a simplified version of your table to start with, for example, the fields from the visual plus one measure, and if you can get that to work, build it up.