Urgent Help

Question

Hello Everyone,&nbsp;I have a table wherein I am making some dynamic calculations using whatif parameters, below is the code:-&nbsp;Revenue Top Seats Top = var a = ADDCOLUMNS(SUMMARIZE(Main,Main[TPID]),"test",[Rev Potential],"test 2",[Seats Potential.]) var Quartile_1 = PERCENTILEX.INC(a,[test],0.25) var Quartile_2 = PERCENTILEX.INC(a,[test],0.75) Var Quartile_4 = PERCENTILEX.INC(a,[test],1) var SeatsQtr1 = PERCENTILEX.INC(a,[test 2],0.25) var seatsqtr2 = PERCENTILEX.INC(a,[test 2],0.75) var seatqtr3 = PERCENTILEX.INC(a,[Test 2],1)var Final = ADDCOLUMNS(a,"Quartile",IF([test]&lt;=Quartile_1,"Bottom Quartile",IF([test]&gt;Quartile_1&amp;&amp;[test]&lt;=Quartile_2,"Middle Quartile",IF([test]&gt;Quartile_2,"Top Quartile"))),"Quartile 2",IF([test 2]&lt;=SeatsQtr1,"Bottom Quartile",IF([test 2]&gt;SeatsQtr1&amp;&amp;[test 2]&lt;=seatsqtr2,"Middle Quartile",IF([test 2]&gt;seatsqtr2,"Top Quartile")))) var last = ADDCOLUMNS(Final,"Revenue Top Seats Bottom",IF([Quartile]="Top Quartile"&amp;&amp;[Quartile 2]="Top Quartile",1,0)) return SUMX(FILTER(last,[Revenue Top Seats Bottom]=1),[Revenue Top Seats Bottom])&nbsp;This code is absolutely running fine, however, when I select any filter the percentiles (Quartile 1...2,Seats Qtr1...Seats Qtr2) all of these quartile variables are also adjusted when I filter my TPID, however, I want to actually make my percentiles static, i.e., even though I select any industry from the slicer, the percentile should always be calculated on the entire column, I have tried usng all and everything but I am stuck here.&nbsp;Can anyone help me calculating thiese percentiles on the entire column by ignoring the outside filters? Remember only percentiles, rest calculation is running smotthly.&nbsp;Thanks.

lbendlin · Answer

Either modify your measure to ignore certain filters (ALL(), REMOVEFILTERS() etc) or use a calculated column instead.

littlemojopuppy · Answer

Not going to even attempt to decipher that code...here's a link to a DAX formatting tool.&nbsp;Look into the ALLEXCEPT() function

datazoe · Answer

Hi&nbsp;v-nchawla&nbsp;, I agree with&nbsp;lbendlin&nbsp;that perhaps REMOVEFILTERS() would work best. I would try putting VAR a in a CALCULATETABLE with REMOVEFILTERS()&nbsp;CALCULATETABLE function (DAX) - DAX | Microsoft Docs.&nbsp;

v-easonf-msft · Answer

Hi,&nbsp;v-nchawla&nbsp;
Could you please tell me whether your problem has been solved?If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,Community Support Team _ Eason

Forum Discussion

Urgent Help

4 Replies

Related content

Urgent question about Policy update

Need Urgent Help on SamePeriodLastYear

urgent help needed

Urgent Help - Power Query - Data Transformation

Urgent ASAP: Paginated Report SubscriptionFailure-AdalExternalSecurityChallengeNotSatisfiedErrorCode