Power BI Exchange

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

Complex relationship and calculation to solve

  • 1.  Complex relationship and calculation to solve

    Gold Contributor
    Posted 13 days ago
      |   view attached

    Hi, I have a table for 1. Product and 2. Service

    I wanted to calculate

    1. Calculate the activity by type i.e. Product, Service and All by region and by station
    2. Cost to be calculated for Product by region and by station
    3. Cost per activity - by product, by region and by station

    I am struggling with it now, could some one help me. Attaching the sample pbix file.

    Thanks in advance.​



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

    Attachment(s)

    pbix
    Region test.pbix   103 KB 1 version


  • 2.  RE: Complex relationship and calculation to solve

    Gold Contributor
    Posted 12 days ago
    Hi @Srikanth Hari, I am almost tempted to say you only need 2 measures for this scenario. Cost and Activity. When you use a slicer or table then you can for example view the cost by the appropriate filter context.​

    ------------------------------
    Shungu Dhlamini
    Power BI Consultant
    shungud@gmail.com
    ------------------------------



  • 3.  RE: Complex relationship and calculation to solve

    Posted 11 days ago

    Hi @Srikanth Hari,

    Please review below points :

    1. Is the data model in the star schema ?
    2. Is there any relation between Trip Booking and Cost?
    3. Is there any relation between Activity and Cost?
    4. Is all relation between tables created correctly?

    Thanks,

    Feras

    ​​​

    ------------------------------
    Feras Alramli
    Oshawa
    ------------------------------