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.
Percent usage in matrix type table in Power BI.
I am in doubt as to how to perform percentages when I go to the next level of drill down in my matrix, the first line was ok, but when I go down the level, 100% is displayed in all data. My base formula is: Total Sales Underline = CALCULATE([Sale Qty Weight KG], ALLSELECTED('Item'[Underline - Name])) % Share Underlines = DIVIDE([Sales Qty Weight KG], [Total Sales Underlines]) but there are other levels that need the percentage. Can someone help me? how I use the other lines, like: Item [Group - Name] Item - Description [Description]
