Club Power BI

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Display the ratio in row

  • 1.  Display the ratio in row

    Posted May 24, 2019 11:30 AM
      |   view attached



    I want to display the ratio in row. It likes the image following.


    But I only realized the ratio in column. I created a measure following to calculate the ratio, but the ratio was show in column.

    Ratio % = DIVIDE(CALCULATE('Query1'[Actual N], FILTER('STAR_Agregated_group_PL','STAR_Agregated_group_PL'[ldesc2]="Net margin")),
    CALCULATE('Query1'[Actual N],FILTER('STAR_Detailed_group_PL', 'STAR_Detailed_group_PL'[ldesc2]="NET ACTIVITY TURNOVER")))

    I don't understand why the sublevel of "NET ACTIVITY TURNOVER" calculate ratio too. 



    Do you have a good ideal?

    I am looking forward to hearing from you soon.


    Best regards.



    TESTXXXXX.pbix   2.88MB 1 version

  • 2.  RE: Display the ratio in row

    Top Contributor
    Posted May 28, 2019 09:01 AM
    Greetings @Wei LI

    See the following article helps


    William Rodriguez
    Business Analyst | MCSA: BI Reporting

  • 3.  RE: Display the ratio in row

    Posted May 29, 2019 03:39 AM
    Hi @William Rodriguez,

    Thank you for your suggestion, but I found a solution yesterday.

    Please See the following article:

    Power BI Exchange
    Pbiusergroup remove preview
    Power BI Exchange
    Hidden page that shows all messages in a thread
    View this on Pbiusergroup >

    Best regards.

    Wei Li