Get Max of a Value Field in Pivot Table from Data Model

[AEAA]

Hi All,

I am trying to do the following, please let me know if this is possible:

I have a "Value Field" called Count of Value_Proficiency which simply counts the occurrence of each Row Label

I would like to create a new "Measure" having Max of Count of Value_Proficiency repeated for all Row Labels. Seems fairly simple, but I cannot get it to work (All the data is in a Data Model and I cannot create calculated fields I think).

I am trying the following -> Create Measure -> MAX([Count of Value_Proficiency]) but this does not work.

In example the max is 471, I would like to divide Sum of Value_Proficiency per row/471

Thank you very much for your help.

 

[Peter_SSs]

Duplicate to: Get Maximum of Value Field in Pivot Table

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the original linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.

If you have posted the other thread in the wrong forum then use the 'Report' button below that other post and explain where you would like the thread moved to.