topic Re: percentage by last week blank in DAX Commands and Tips

percentage by last week blank

reibalboaOMG — Fri, 10 Mar 2023 02:15:17 GMT

Hi Everyone,

I'm having a problem on my formula

here in my dashboard i have week 2 and 3

both weeks are showing correct % but when i switch on a duration it goes blank

here is my formula

percentageforsoc = IF(ISBLANK([lastweekcpm]), BLANK(), ([lastweekcpm]-[thisweekcpm])/[lastweekcpm])

if the date changes the lastweekcpm turns to blank,

so that's why the cards go blank, is there a way for me to show it? and dont summarize the %

thanks for the response

Re: percentage by last week blank

andhiii079845 — Fri, 10 Mar 2023 08:57:43 GMT

Hi,
You have to show us the involved tables, columns and measures. I think a upload (via ondrive, dropbox) with a example without senstive data will be the easist way. 🙂

Re: percentage by last week blank

reibalboaOMG — Mon, 13 Mar 2023 01:03:41 GMT

Hey andhiii079845

here's my lastweekformula

lastweekcpm = CALCULATE([Postimpcpm] ,ALLSELECTED('Template (2)'),'Template (2)'[weekrank] = MAX('Template (2)'[weekrank])-1)

thisweeks formula

thisweekcpm = CALCULATE([Postimpcpm] ,ALLSELECTED('Template (2)'),'Template (2)'[weekrank] = MAX('Template (2)'[weekrank]))

percentageforsoc = IF(ISBLANK([lastweekcpm]), BLANK(), ([lastweekcpm]-[thisweekcpm])/[lastweekcpm])

and the

postimpcpm:

Postimpcpm =

1000 * DIVIDE(SUM('Template (2)'[Cost/Post]), SUM('Template (2)'[Post Impression]))

Re: percentage by last week blank

reibalboaOMG — Wed, 15 Mar 2023 09:34:46 GMT

andhiii079845 since it's a dummy data that i'm using do you want the pbix file?

Re: percentage by last week blank

andhiii079845 — Wed, 15 Mar 2023 09:55:10 GMT

This will be great! 🙂

Re: percentage by last week blank

reibalboaOMG — Thu, 16 Mar 2023 01:13:13 GMT

Where can i send the pbix, email?, i'm trying to attach the files here but the file was not supported for attachment

Re: percentage by last week blank

andhiii079845 — Thu, 16 Mar 2023 06:04:12 GMT

Upload it via onedrive or dropbox and share the link 🙂

Re: percentage by last week blank

reibalboaOMG — Fri, 17 Mar 2023 01:18:57 GMT

andhiii079845 here's the link Project Lift off 2.pbix,

please reach me if you're having difficulty in accessing