Forum Discussion
DAX
Hi All, I'm trying to solve one User requirement in my power BI I have a two tables one id Dim_Table and another is Fact_Table In Dim table I have a column News and Content In News I have...
amitchandak
Super User
Super UserAnonymous , You use TOPN and Windows for that
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit, Thanks for replying
That is not working as expected for mr , I'm sharing sample data with you
| News | Content | Views |
| Globe News | Testing is happening | 20 |
| Globe News | Testing is done | 16 |
| Globe News | Into Prod | 18 |
| Locality News | Local Tag #Localality News 2 | 15 |
| Locality News | Local Tag #Localality News 1 | 18 |
| Region News | Testing Region News #1 | 29 |
| Region News | Testing Region News #2 | 4 |
| Region News | Testing Region News #3 | 6 |
Here For Globe News I need to show only highest Content Views
In heer For Globe News Highest Content Views is 20
I need to show that Highest View Content only and also Views for that content
Same for Locality News and Region News
Please Help
Thanks in advance