Forum Discussion
Create Measure that Counts Total Rows when added to Table
My goal is to create a summary table containing a measure that scores each ZIP based on facility % share, where the highest share has a score of 100%. I'm starting with a source data table similar t...
Hello patshannon11 ,
please check if this what you need.
ZIP Count = CALCULATE(MAXX('Table','Table'[Facility Share RANK]),ALL('Table'))
Hope this will help you.
Thank you.
Thank you.
Thank you for the response. One nuance I failed to mention was the count should also update based on filtering. For example: if I filter on ZIP 10001, 10002, 10003, 10004 ,and 10005 the count should update to 5 so that the highest Facility % Share still scores 100%.
