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.
Calculate the percentage of table matrix as well as subtotals
I need to calculate the Share of the below table, I was able to calculate in Pbi the share per Brand by using this DAX =DIVIDE([Sales_], CALCULATE([Sales_], ALLEXCEPT('tblProduct','tblProduct'[Brand_name]))) However subtotal needs to calculate the share base on column total (sub-total / Column Total) In my case sub-total is returning 100% Requirements: i write here as well the excel formula (Column F) on how to calculate the share and its sub-total.
