How to get Selected Value from the filter when there's no data

Hello parry2k ,

Thanks for your response.

It works fine, everything is happy when there's data for the date range selected, but when there's no data for the date range, then both the project seelction and date range selections come up as blanks, as a result I can't calculate/count cumulative data that are available for the project that falls outside/prior to the date range, because if I don't know what the selected project and date range is, how can I do anything. There must be a way to directly fetch it from the slicers (despite no data available for the selection).

From the image above,first 3 columns are for selected period, which are 0s (correct, as there's no data for the range selected for the project). But next 3 columns are for cumulative, and they have data.

But as I said, when there's no data for the period, I am not able to know what project or date range was selected because they return blank e.g. SELECTEDVALUE('MyTable'[Project]). That's why counting doesn't work without project or date information.

Hope I am able to clarify.

Regards,

nhuda