Forum Discussion
COUNTROWS Function
Sorry, I'd focussed on the SUMMARIZE and totally missed what the SELECTCOLUMNS was doing!
When you add the COUNTROWS in have you tried dropping the measure into a card on an empty page with no report filters set. Just wondering if something is already in the filter context.
Hello bcdodds,
Thanks very much for your help.
In fact, the function INTERSECT has two parameters (tables). If you look deeply you will notice that each one of them(parameters) is a table with only one columns named "BaselineCode". The columns "DateLastRDV" are not kept in the both parameters of INTERSECT because I knew what you have just said, which is absolutely true (Look at SUMMARIZE).
Then the function INTERSECT works well when it is excuted without COUNTROWS. It returns a table with a single columns named "BaselineCode".
My challenge is to count the number of rows of the result of INTERSECT function; but the function COUNTROWS is not working.
I hope it is a little more clear now? If not, please come back to me.
Sorry, I'd focussed on the SUMMARIZE and totally missed what the SELECTCOLUMNS was doing!
When you add the COUNTROWS in have you tried dropping the measure into a card on an empty page with no report filters set. Just wondering if something is already in the filter context.