topic Re: View rows counted in CountX function in DAX Commands and Tips

View rows counted in CountX function

SEunson — Tue, 05 Jul 2022 07:45:29 GMT

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],

ISBLANK(TableA[End Date]) || TableA[End Date] >= [Month Start]

TableA[ID]

)
)

These results are then shown on a line graph, with month on the x axis.

I would like to visualise the rows that have been counted in a table, so I can see further details on the counted rows.

Drill though does not work because the rows counted for a specific month do not necessarily fall within that month.

Does anyone have any suggestions?

Thanks!

Re: View rows counted in CountX function

johnt75 — Tue, 05 Jul 2022 08:12:52 GMT

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

Re: View rows counted in CountX function

SEunson — Tue, 05 Jul 2022 10:56:47 GMT

Hi johnt75,
Thanks for the response. I'll have a look into this. Will let you know how I get on.

Re: View rows counted in CountX function

SEunson — Wed, 06 Jul 2022 12:45:09 GMT

Hi, I tried your suggestion out. I can't get it to work as a filter. But if I put the new measure in a table along with the other fields I want to see, it seems to work ok then. I'm not too sure why that is... but anyway, it's better than I had before, so thanks.