Calculation Headeach
I Have this type of data And I want to run a repport like this The first repport work fine, but when i collapse the society, the cumulative to do is not the cumulative I want (The cumulative for all the society regardless the month). If you have ideas please don't hesitate to give me your feedback. Kind regards
max measure is showing infinity value
hello i created 2 measures to find the max and min percentage of another measure. the dax code to create the 2 measures is the same the only difference is in the minimum measure i used (minx) and in the maximum measure i used (max). although the 2 measures are exactly the same , the max measure it showing me (infinity ) in case the percentage is greater than 100% and the minimum function is working properly. i cant understand why it's showing inifinty and not the correct percentage this the code for the minumum percentage measure Min New Achievement % overall = CALCULATE( minX(SUMMARIZE('categories trans','categories trans'[AGENT_ID],'categories trans'[AGENT_NAME],'categories trans'[TRANSDATE (bins)],'categories trans'[base type without zeed],'categories trans'[categories summarize],'Agents list'[Position],'categories trans'[CHANNEL],'Agent Rate Key'[Agent Rate]),[achiev of overall]),ALL('Agents list'[Position]),ALL('categories trans'[categories summarize],'categories trans'[base type without zeed]),'categories trans'[achievement],ALL('Agent Rate Key'[Agent Rate]),'categories trans'[categories summarize]<>BLANK()) this is the code for the max percentage measure Max New Achievement % overall = CALCULATE( maxX(SUMMARIZE('categories trans','categories trans'[AGENT_ID],'categories trans'[AGENT_NAME],'categories trans'[TRANSDATE (bins)],'categories trans'[base type without zeed],'categories trans'[categories summarize],'Agents list'[Position],'categories trans'[CHANNEL],'Agent Rate Key'[Agent Rate]),[achiev of overall]),ALL('Agents list'[Position]),ALL('categories trans'[categories summarize],'categories trans'[base type without zeed]),'categories trans'[achievement],ALL('Agent Rate Key'[Agent Rate]),'categories trans'[categories summarize]<>BLANK()) the is the [achiev of overall] measure achiev of overall = [core achievement]+[access achiev 10%] this is the result max measure should show the value 149.82% instead of infinity note that i had to use summarize function as i want to show the min/max achievement percentage per agent, category, category type, and position and then find the maximum and minimum value percentage among all categories.Max Total Sales in Matrix Year and countries
Dear community, I'm trying in a Matrix to retrieve the Maximum Total Sales of all the Year by countries. Very simple in theory, but it seems more complex in reality as I need to remove the Year filter to place the measures inside the matrix. But removing the all(Year) also changes the context of my Max formula. I tried turnaround with Supporting tables, but it doesn't seem to work as I loose the Year with my technics. Any straight forward methods? Faced this problematic more than once :slight_smile: Thanks for you help! Mark Lovejoy
