Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Reports

    Gold Contributor
    Posted Jan 12, 2022 02:15 PM
      |   view attached
    Dear experts, Need the help to get the desired report result as per attached - pls help

    File attached
    test report


    ------------------------------
    FA
    ------------------------------

    Attachment(s)

    pbix
    test report.pbix   83 KB 1 version


  • 2.  RE: Reports

    Posted Jan 13, 2022 11:05 AM
      |   view attached
    I am sure others will have more elegant approaches, but i noticed a few things ...

    The first issue is an easy formatting issue - For the matrix visual got to Row Headers and turnoff stepped layout. this will give you the format you desire.


    Secondly, your measures look correct, but the issue is being driven by the 2 tables (fact tables) attached to the single dimension table and the measure being calculated across both. Essentially you have no relationship established on the dates in the 2 tables, thus the calculations are wrong. Try consolidating the activity and cost tables into a single fact table.

    Attached example


    ------------------------------
    Bob Parsons
    Business Intelligence Manager
    Star Produce
    Calgary, AB
    ------------------------------

    Attachment(s)

    pbix
    test report2.pbix   102 KB 1 version