cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ResearchDev
Helper II
Helper II

Need advise on how to recreate this

ResearchDev_0-1654872462243.png     

ResearchDev_1-1654872619435.png

 

The list Project # Total is quite a bit more to the right but I showed only a small subset. This is what I did: I create a list > add datasource and then do a sum or then CountDistinct on some of the rows across while some are SUM and others but I had to add a filter to the tablix (see above). The problem is I tried to add a row below on the same table within the tablix and just add another filter in the tablix properties like above, the data comes out incorrect. Do I really need to add this slow approach then Like this: Add list > Add table > add filter in tablix for each and every ROW? Thanks

 

1 ACCEPTED SOLUTION
ResearchDev
Helper II
Helper II

Never mind I think I figured it out by doing something similar to the above. Have a big list > add separate tables with their own Filters and it works. 

View solution in original post

1 REPLY 1
ResearchDev
Helper II
Helper II

Never mind I think I figured it out by doing something similar to the above. Have a big list > add separate tables with their own Filters and it works. 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors