Skip to main content
cancel
Showing results for 
Search instead 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

Reply
arikofather
Frequent Visitor

Cross Filtering Count Table from Unconnected table

Please see attached PBIX

Pipleline Period Report 2.pbix

 

Here is the Dataset:

arikofather_0-1718640337546.png

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

arikofather_5-1718640944253.png

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

arikofather_6-1718640984510.png

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

arikofather_7-1718641059111.png

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

arikofather_8-1718641121464.png

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.  

arikofather_9-1718641203981.png

arikofather_10-1718641229670.png

 

 

 

 

1 ACCEPTED SOLUTION
v-xingshen-msft
Community Support
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])

vxingshenmsft_1-1718704210210.png

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.

View solution in original post

2 REPLIES 2
v-xingshen-msft
Community Support
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])

vxingshenmsft_1-1718704210210.png

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

 

Jihwan_Kim_0-1718682493212.png

 

 

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.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.