Forum Discussion
Cross Filtering Count Table from Unconnected table
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.
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.
2 Replies
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.
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.
