Forum Discussion

conniedevina's avatar
conniedevina
Helper I
4 years ago
Solved

Custom Matrix Table Power BI based on measures

Hi All, I'm having little bit problem, so I want to create custom matrix table for KPI and hoping it would look like this  So for Budget I have this measure to calling each measures Bud...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi conniedevina ,

    I updated your sample pbix file(see attachment), please check whether that is what you want. You can create another new two measures as below and put them on the matrix to replact the original measures [Budget] and [Actual]:

    nBudget = 
SUMX (
    GROUPBY ( 'KPI Report', 'KPI Report'[KPI], 'KPI Report'[Shift Order] ),
    [Budget]
)
    nActual = 
SUMX (
    GROUPBY ( 'KPI Report', 'KPI Report'[KPI], 'KPI Report'[Shift Order] ),
    [Actual]
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi conniedevina ,

I updated your sample pbix file(see attachment), please check whether that is what you want. You can create another new two measures as below and put them on the matrix to replact the original measures [Budget] and [Actual]:

nBudget = 
SUMX (
    GROUPBY ( 'KPI Report', 'KPI Report'[KPI], 'KPI Report'[Shift Order] ),
    [Budget]
)
nActual = 
SUMX (
    GROUPBY ( 'KPI Report', 'KPI Report'[KPI], 'KPI Report'[Shift Order] ),
    [Actual]
)

Best Regards