Forum Discussion

pbisupport1717's avatar
pbisupport1717
New Member
2 years ago
Solved

Power BI DAX Expansion on Matrix

Okay so I am making a power bi report. I have the following rows (all in one table) visualized as matrix. in brackets is what the rows refer to Within the Entries table Groups.name (Department) ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, pbisupport1717 

    We need to make sure that the denominator remains the same at all levels of the matrix, regardless of the drill-down level. You might want to try the following DAX

    Cap Hours% = 
DIVIDE(
    [App Dev Hours],
    CALCULATE(
        [User Total Hours],
        REMOVEFILTERS(Entries[Tasks.level 1 Name]),
        REMOVEFILTERS(Entries[Name])
    )
)


    In this formula, any filters applied to the column are used to remove when drilling down, ensuring that the calculation is based on the total number of hours logged by the user across all tasks and parent projects.

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, pbisupport1717 

We need to make sure that the denominator remains the same at all levels of the matrix, regardless of the drill-down level. You might want to try the following DAX

Cap Hours% = 
DIVIDE(
    [App Dev Hours],
    CALCULATE(
        [User Total Hours],
        REMOVEFILTERS(Entries[Tasks.level 1 Name]),
        REMOVEFILTERS(Entries[Name])
    )
)


In this formula, any filters applied to the column are used to remove when drilling down, ensuring that the calculation is based on the total number of hours logged by the user across all tasks and parent projects.

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.