Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago
Solved

Count Maximum Code based on Key in Summarized Table

Having a nightmare today, mind has gone blank (spending too much time on the one dashboard) I have a summarized table (code below) which brings back the following table when created. As you can see...
Need Help
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi Anonymous ,

    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

     

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi Anonymous ,

I've created a sample .pbix file showing how to get the maximum VALUE per KPI per cost centre and also how to pull related info like Period_key.

The file has Sample data with multiple rows per KPI.

Measures for Max VALUE and related details.

 

Please find the below attached .pbix file

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    Hi Anonymous ,

    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.