Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Amit, Thanks for replying
    That is not working as expected for mr , I'm sharing sample data with you

    NewsContentViews
    Globe NewsTesting is happening20
    Globe NewsTesting is done16
    Globe NewsInto Prod18
    Locality NewsLocal Tag #Localality News 215
    Locality NewsLocal Tag #Localality News 118
    Region NewsTesting Region News #129
    Region NewsTesting Region News #24
    Region NewsTesting Region News #36


    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