Cross Filtering Count Table from Unconnected table

[arikofather]

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.  

[Anonymous · Accepted solution]

Hi @arikofather ,

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.

[Jihwan_Kim]

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.