Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Solve "Inner Join" Logic by using measures?

    Posted Apr 29, 2022 05:15 AM
    Hi All,

    I have the following problem and hope someone can help me out:

    I have two tables that I use to calculate a KPI. The first table contains information regarding revenue for 10 buildings and the second table contains information about square meter (Area) for 20 buildings. So there is information on square meter for more buildings then we have on revenue. Only for 10 buildings we have both information.

    Now, if I want to calculate the average revenue per SQM and I sum up all the revenue (of the 10 buildings) and all the area (from the 20 buildings) I obviously get a wrong result.

    Is there any way to solve this via a measure in the calculation to say: Only take the SQM values of the 10 buildings where there is the respective other value? I know a workaround is to create a view on the server that performs an inner join but I would need to do this for a lot of KPIs.

    Any help would be much appreciated.

    ------------------------------
    Dominik Jakob
    ------------------------------


  • 2.  RE: Solve "Inner Join" Logic by using measures?

    Posted Apr 30, 2022 12:54 AM
      |   view attached
    Veja se o pbix em anexo ajuda



    ------------------------------
    Vilmar Santos
    ------------------------------

    Attachment(s)

    pbix
    buildings.pbix   30 KB 1 version