Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

How to model and aggregate rate (dimension) and amount (fact) per Kimball “header/line item” ?

Hello, I am working on a Power BI model for cloud billing (Azure Cost Management) and trying to follow the guidance from Kimball Group’s “header/line item transaction” modeling patterns: https://ww...
Need Help
jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago

Hello jaineshp .

It could be nice but I afraid about having too many shared dim tables in a model. It will be difficult to handle. 
What about DAX statement? 
Could i handle it as measure? 

p.s. I know yur answer from chat gpt. But really is the solution from real life example? 

Best,
Jacek

  • jaineshp's avatar
    jaineshp
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Hi jaryszek ,

    Totally understand your concern, having too many shared dimensions in a model can make it feel heavy and harder to manage, especially if the fact tables keep growing.

    DiscountEffectivePrice (Avg) :=
    CALCULATE(
    AVERAGE('Fct_EA_AmortizedCosts_DiscountPlans'[DiscountEffectivePrice]),
    TREATAS(
    VALUES('Fct_EA_AmortizedCosts'[OfferId]),
    'Fct_EA_AmortizedCosts_DiscountPlans'[OfferId]
    ),
    TREATAS(
    VALUES('Fct_EA_AmortizedCosts'[ResourceLocationNormalized]),
    'Fct_EA_AmortizedCosts_DiscountPlans'[ResourceLocationNormalized]
    ),
    TREATAS(
    VALUES('Fct_EA_AmortizedCosts'[PricingModel]),
    'Fct_EA_AmortizedCosts_DiscountPlans'[PricingModel]
    )
    )

    Hope this helps!

    Best Regards,
    Jainesh Poojara | Power BI Developer