Can this measure be optimized in speed?
I have this measure that is used to rank customers. In the data model it is 4 different measure, and the final ranking / priority measure is this: Prio = IF ( [RFV DM] > 1, 1, IF ( [Historisk god hitrate] > 0 && [RFV DM] <= 1, 2, IF ( [Lotteri spillere] > 0, 3, IF ( [Doner minus brev] > 0, 4,0)))) Where RFV DM = VAR RFV = CALCULATE( ([Direct mail Bidrag])/([Antal Direct Mails]*Brevpris[Værdien Brevpris]) ) RETURN IF( [Antal Direct Mails] > 0, RFV, BLANK()) Historisk god hitrate = VAR MinAntalBidrag = MIN( 'StøttebrevePrio2'[Antal støttebreve prioritet 2] ) VAR MaksAntalBidrag = MAX( 'StøttebrevePrio2'[Antal støttebreve prioritet 2] ) VAR MinAntalLotteri = MIN( LotteribrevePrio2[Antal lotteribreve prioritet 2] ) VAR MaksAntalLotteri = MAX( LotteribrevePrio2[Antal lotteribreve prioritet 2] ) VAR MailSum = IF ( [Antal Direct Mails] >= MinAntalBidrag && [Antal Direct Mails] <= MaksAntalBidrag, 1, 0) VAR LotteriSum = IF ( [Antal Lotteri breve] >= MinAntalLotteri && [Antal Lotteri breve] <= MaksAntalLotteri, 1, 0) VAR DirectCnt = IF ( MailSum = 1 && LotteriSum = 1, CALCULATE( COUNTROWS( Splittest ), Splittest[DirectMail bidrag] > 0 ), 0 ) RETURN IF ( DirectCnt >= AntalDonationerPrio2[Antal donationer prio2], DirectCnt) Lotteri spillere = VAR MinAntalBidrag = MIN( 'StøttebrevePrio3'[Antal støttebreve prioritet 3] ) VAR MaksAntalBidrag = MAX( 'StøttebrevePrio3'[Antal støttebreve prioritet 3] ) VAR MinAntalLotteri = MIN( LotteribrevePrio3[Antal lotteribreve prioritet 3] ) VAR MaksAntalLotteri = MAX( LotteribrevePrio3[Antal lotteribreve prioritet 3] ) VAR MailSum = IF ( [Antal Direct Mails] >= MinAntalBidrag && [Antal Direct Mails] <= MaksAntalBidrag, 1, 0) VAR LotteriSum = IF ( [Antal Lotteri breve] >= MinAntalLotteri && [Antal Lotteri breve] <= MaksAntalLotteri, 1, 0) VAR LotteriCnt = IF ( MailSum = 1 && LotteriSum = 1, CALCULATE( COUNTROWS( Splittest ), Splittest[Lotteri bidrag] > 0 ), 0 ) RETURN IF ( LotteriCnt >= AntalDonationerPrio3[Antal donationer prio3], LotteriCnt) Doner minus brev = VAR MinAntalBidrag = MIN ( 'StøttebrevePrio4'[Antal støttebreve prioritet 4] ) VAR MaksAntalBidrag = MAX ( 'StøttebrevePrio4'[Antal støttebreve prioritet 4] ) VAR MailSum = IF ( [Antal Direct Mails] >= MinAntalBidrag && [Antal Direct Mails] <= MaksAntalBidrag, 1, 0 ) VAR AndetCnt = IF ( MailSum = 1, CALCULATE ( COUNTROWS ( Splittest ), Splittest[Andet bidrag] > 0 ), 0 ) RETURN IF ( AndetCnt >= [Antal donationer prio4], AndetCnt ) Each measure is ranking the customers under different conditions. That is why I have different variables in each measure. The measure prio makes sure that it ranks in correct order. all measures look through about 4 million plus rows, so it takes like 16-20 sec before the report returns data if a filter is changed. Also each measure takes about 4 seconds each if I look in the optimizer. Is it possible to optimize the speed though changing the DAX?
Deprecated REST API request slows down the portal drastically
Hello, I have a problem on my portal with the API request `/api/v.2.0/me`. I'm running my report server locally, and my portal is super slow (12 seconds for each page) I looked at the network, and the request for catalog items is done instantly. Then I discovered that SSRS is doing the /me request to see what my role is after giving me that data... The me request was the catalog items from showing. Also it says in the cookies that this request is deprecated. Is there/will there be a fix for this ? Thank you,
Size of HTML from PBI Report Server almost 10x bigger then HTML from PowerBI.com
Hi, I have a Power BI report with imported data. When I publish this to PowerBI.com and run the Internet Explorer development tools the size of the data loaded is ca. 3MB. When I publish this same report to the Power BI Report server the size of the data which is 'downloaded' is over 26MB. Can someone tell me why this is and how to solve this? It look like the userenvironments have difficulties loading the 26MB of HTML. Thanks.
