Forum Discussion

alku0530's avatar
alku0530
Regular Visitor
2 years ago

How to create an interactive table in report which counts rows of another table by group and filter

Dear all,   I am new to power bi(<1 week), but have tried any possible solution in the past few days with no progress. Really need your help.   I am tasked to create an interactive report using p...
Need Help
gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi alku0530 

 

I took a look at your model and made a couple of small changes.

 

Usually I would leave a parameter table like Percentile as a disconnected table.  If your Percentile column in 'Table (1)' is always a whole number between 0 and 100, you can create a one-to-many relationship between 'Percentile'[Percentile] and 'Table (1)'[Percentile] and filtering will handle everything else.

 

(With a disconnected table, you would need one or more [Include] measures to filter table visuals.  Filtering 'Table (1)' is no problem but 'Table (2)' is tougher.)

 

Let me know if you have any questions.

 

Interactive tables - 2.pbix

 

 

Also, I'm not sure what your Cost slicer is for.