Forum Discussion

Xeth's avatar
Xeth
Frequent Visitor
2 years ago
Solved

Need help in building matrix/card visual with diff aggregation depending on data

With the following sample data (Blue columns) Column Capa has been created as a measure (FC/Plan) and added as a column to the table (to get aggregation) Column Utilization has also been cre...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Xeth ,

     

    According to your description,we can update two measures.

    Capa = DIVIDE(SUM('Table'[FC]),SUM('Table'[Plan]))
    Utilization = DIVIDE(SUM('Table'[Actuals]),SUM('Table'[FC]))

    Then the result is as follows.

    As for the HC column, what is your logic and expected outcome?

    If I have misunderstood you, please clarify in a follow-up reply. Please provide sample data and your expected result with backend logic and special examples.

     

    Best Regards,

    Neeko Tang

    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 Xeth ,

 

According to your description,we can update two measures.

Capa = DIVIDE(SUM('Table'[FC]),SUM('Table'[Plan]))
Utilization = DIVIDE(SUM('Table'[Actuals]),SUM('Table'[FC]))

Then the result is as follows.

As for the HC column, what is your logic and expected outcome?

If I have misunderstood you, please clarify in a follow-up reply. Please provide sample data and your expected result with backend logic and special examples.

 

Best Regards,

Neeko Tang

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