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.
Here it is the situation.
I want know the simplest way to handle aggregated/Grouped data. If menu buttons can work it out (instead of coding) better. I need to calculate ranking scores, filter according to these and probably also filter according dynamics dates/indexes.
Here my questions:
I hope i could express my questions clear enough. Just ask if need further explanation.
Thanks for your attention
Solved! Go to Solution.
Hi @Nachospt,
No. You can also open Query Editor, then use Group By button to group data based on prefer field.
Or you needn't to do anything about data model, you can only place those fields in the table visual and check aggregate function like this:
In DirectQuery, it's also possible to create a measure and calculated column using DAX. You can take a look at this article: Ability to create measures when using DirectQuery mode.
Yes, we can use "Group by" in edit query to group data, then build relationship betwene this new table with fact table. In my opinion, "Group by" is better.
In DirectQuery, relationship filtering is limited to a single direction, rather than both directions. You can use SQL Sevrer Profiler to minitor backend query execution time when you filter or refresh data. Also please take a look at Limitations of DirectQuery and Important considerations when using DirectQuery sections in this article: Use DirectQuery in Power BI Desktop.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi @Nachospt,
No. You can also open Query Editor, then use Group By button to group data based on prefer field.
Or you needn't to do anything about data model, you can only place those fields in the table visual and check aggregate function like this:
In DirectQuery, it's also possible to create a measure and calculated column using DAX. You can take a look at this article: Ability to create measures when using DirectQuery mode.
Yes, we can use "Group by" in edit query to group data, then build relationship betwene this new table with fact table. In my opinion, "Group by" is better.
In DirectQuery, relationship filtering is limited to a single direction, rather than both directions. You can use SQL Sevrer Profiler to minitor backend query execution time when you filter or refresh data. Also please take a look at Limitations of DirectQuery and Important considerations when using DirectQuery sections in this article: Use DirectQuery in Power BI Desktop.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Thanks
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |