Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I've one table with duplicate rows. Now I've to create two reports 1. Detailed Report and 2. Summary Report within one single page.
Now Detailed report contains only dinstinct values but summary report calculates with duplicate rows.
What I've done is write two separate sql queries and import same table two times. But I've one filter column. So when I select filter values it should reflect in both tables. But it's not happening because it only reflects in one table from where it belongs.
Please suggest me how can I apply that.
Hi,
Share some data and show the expected result.
what are the common columns in both tables?
if possible, post sample data.
Hi @Nirmalya45 ,
Please dont load two tables
1) Load your table
2) Create measuers by using DistinctCount Dax Expression to create report .
Plese provide data and your requirement for futher assistance.
Please mark as solution if this works for you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |