Forum Discussion
Reporting different counts on a date column
Anonymous
When you use CALCULATE in a column multiple times, there is context transition, and circular dependency occurs.
I think the best way to solve your problem is using a disconnected table as follows. Please refer to the attached PBIX file. I created a dummy date table, you can replace it with your expires column.
Anonymous
What is the Custom Visual that you are using here?
You select the visual, drag and drop the Expiry Bracket field to the Visual filter in the filter pane and select each item for each visual.
Thanks. That is the Tachometer visual (I don't think it's custom?). I have four of them in a row.
I have dragged the Expiry Bracket field, however that is just a blank text field?
Anonymous
You can set the bracket as follows in the filters paneThanks.
I think this is too complicated for me!
When I select that it just brings back the value set in the table (15). The same as in your example above. Do you know how I can get that to display the count of all dates in my table where the column 'Expires' fall within the 15 day range?
Anonymous
My Measure counts the number of dates on Expires column that fall within the 15-day range from today when you tick "Expires in 15 Days". You can assign the respective selection from the filter pane for 4 of these visuals. I attached the file for you.
If this does not help you, please share a sample file showing where it is going wrong and what you expect as results.