cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Cross Filtering Count Table from Unconnected table

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

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.

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.