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

    Hi,

     

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

    Capture.JPG

    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. 

     

    Ratio.PNG

    Do you have a good ideal?

    I am looking forward to hearing from you soon.

     

    Best regards.



    ------------------------------
    Wei
    ------------------------------

    Attachment(s)

    pbix
    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

    https://www.daxpatterns.com/handling-different-granularities/

    Thanks!
    William​

    ------------------------------
    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
    Supervisor
    +33180491300
    ------------------------------