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. ...
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.
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.