Forum Discussion
Measure changing result when switching from localhost SASS model to live server connection
Hello Community, I have a measure that calculates how many of my vendors make up 80% of my spend. It works perfectly when I am connected through localhost (that's how I created it and tested it),...
If I had to guess, it is EARLIER. It is not on the list of supported DAX functions for your scenario:
Try this:
VAR temp = SUMMARIZE(Vendor,Vendor[VEND_ID],"% Spend", [% of Total Amount Spend])VAR temp1 = ADDCOLUMNS(temp,"RANK",RANKX(temp, [% Spend],,DESC,Dense))VAR temp2 = ADDCOLUMNS(temp1, "Cumulative",VAR __Rank = MAX([RANK]) RETURN SUMX(filter(temp1,[RANK] <= __Rank)), [% Spend]))RETURNMINX(filter(temp2,[Cumulative]>.8),[RANK])
Greg_Deckler
Community Champion
Community ChampionIf I had to guess, it is EARLIER. It is not on the list of supported DAX functions for your scenario:
Try this:
VAR temp = SUMMARIZE(Vendor,Vendor[VEND_ID],"% Spend", [% of Total Amount Spend])
VAR temp1 = ADDCOLUMNS(temp,"RANK",RANKX(temp, [% Spend],,DESC,Dense))
VAR temp2 = ADDCOLUMNS(temp1, "Cumulative",VAR __Rank = MAX([RANK]) RETURN SUMX(filter(temp1,[RANK] <= __Rank)), [% Spend]))
RETURN
MINX(filter(temp2,[Cumulative]>.8),[RANK])
thank you a bunch! It worked!!!