Forum Discussion

sakBI's avatar
sakBI
Frequent Visitor
3 years ago
Solved

Regrouping costs per level

Dear community, I'm trying to build a Power BI report to do Azure Cost recovery. We have 2 kinds of customers: Level 1 Use Azure Level 2 Use Azure + Consultancy services (a percentage on the top...
Need Help
Tips and Tricks
  • sakBI's avatar
    sakBI
    3 years ago

    Sorry,

    I found it very difficult to explain even to my colleagues, but this formula worked finally .
    _Applicable = IF ( SELECTEDVALUE(CostRecovery[SD]) < 1 , CALCULATE(SUM(Usage_details_Bill[L1_Cost]),CostRecovery[Service ID] = "SC-DCT-001"),CALCULATE(SUM(Usage_details_Bill[L2_Cost]),CostRecovery[Service ID] = "SC-DCT-006"))

sakBI's avatar
sakBI
Frequent Visitor
3 years ago

Sorry,

I found it very difficult to explain even to my colleagues, but this formula worked finally .
_Applicable = IF ( SELECTEDVALUE(CostRecovery[SD]) < 1 , CALCULATE(SUM(Usage_details_Bill[L1_Cost]),CostRecovery[Service ID] = "SC-DCT-001"),CALCULATE(SUM(Usage_details_Bill[L2_Cost]),CostRecovery[Service ID] = "SC-DCT-006"))