topic Cross Filtering Count Table from Unconnected table in DAX Commands and Tips

Cross Filtering Count Table from Unconnected table

Anonymous — Mon, 17 Jun 2024 17:12:38 GMT

Please see attached PBIX

Pipleline Period Report 2.pbix

Here is the Dataset:

1. If Period 28 days (<= 28 days) days Selected,

2. If Period 3 Months (<= 90 days) Selected

3. If Period 6 Months (<= 180 days) Selected

4. If Period 1 Year (<= 365 days) is Selected

ASK:

The challenge is to create a count of Deal Stage measure added to the Deal Stage Count Table visual to corectly filter the table with visual by Stage filter.

And also cross filter the detail table with the Stage filter.

Re: Cross Filtering Count Table from Unconnected table

Jihwan_Kim — Tue, 18 Jun 2024 03:48:31 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

Re: Cross Filtering Count Table from Unconnected table

Anonymous — Tue, 18 Jun 2024 09:50:47 GMT

Hi Anonymous ,

Thank you Jihwan_Kim very much for the solution, and I've tried a little bit to have simpler expressions to help you understand the problem:

Measure = var _t = SUMMARIZE('Opportunities',[Name],[Stage],[Days from Closed Date]) RETURN COUNTAX(FILTER(_t,[*Show Rows]=1),[Stage])

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.