Current day sale vs the Previous day sale - KPI ticker by MAQ Software

[gauravnarchal]

Hello - I want to show the current day sale vs the previous day sale of all agents in the KPI ticker by MAQ Software visual.  I have created the below measure but is getting the incorrect results. Can you help me on this?

Day Sales Today = CALCULATE([Total Sales], 'Calendar Ultimate'[Date] = TODAY())

Day Sales Prev Day = CALCULATE([Total Sales], PREVIOUSDAY('Calendar Ultimate'[Date]))

Data is as below

Table 1

InvoiceID	InvoiceNumber	Agent	InvoiceDate
1096133	1009494	1628	13-Nov-21
1095844	1843125	1742	13-Nov-21
1095847	1843131	501	13-Nov-21
1095850	1843134	1757	13-Nov-21
1096035	1843135	1757	13-Nov-21
1095851	1843136	501	13-Nov-21
1096260	1843137	501	13-Nov-21
1095852	1843138	501	13-Nov-21
1095853	1843139	501	13-Nov-21
1095854	1843140	501	13-Nov-21
1095855	1843141	501	13-Nov-21
1095856	1843142	501	13-Nov-21
1095857	1843143	501	13-Nov-21
1095859	1843145	1668	13-Nov-21
1095860	1843146	501	13-Nov-21
1095861	1843147	501	13-Nov-21
1095862	1843148	501	13-Nov-21
1095865	1843150	501	13-Nov-21
1095866	1843151	501	13-Nov-21
1095867	1843152	501	13-Nov-21
1095869	1843154	501	13-Nov-21
1095870	1843155	501	13-Nov-21
1095871	1843156	1747	13-Nov-21
1095872	1843157	501	13-Nov-21
1095874	1843159	1747	13-Nov-21
1095875	1843160	501	13-Nov-21
1095876	1843161	1747	13-Nov-21
1095877	1843163	1747	13-Nov-21
1095879	1843165	1668	13-Nov-21
1095883	1843167	501	13-Nov-21
1095885	1843170	501	13-Nov-21
1095886	1843171	501	13-Nov-21
1095887	1843172	501	13-Nov-21
1095889	1843173	1668	13-Nov-21
1095890	1843174	1668	13-Nov-21
1095891	1843175	1668	13-Nov-21
1095892	1843176	1747	13-Nov-21
1095893	1843177	501	13-Nov-21
1096059	1843178	1749	13-Nov-21
1095894	1843179	501	13-Nov-21
1096014	1843180	1747	13-Nov-21
1095895	1843181	501	13-Nov-21
1095900	1843183	1749	13-Nov-21
1095897	1843184	501	13-Nov-21
1095898	1843185	501	13-Nov-21
1095902	1843186	1749	13-Nov-21
1095899	1843189	501	13-Nov-21
1095939	1843191	1668	13-Nov-21
1095940	1843194	1668	13-Nov-21
1095904	1843195	501	13-Nov-21
1095905	1843196	1747	13-Nov-21
1095906	1843197	501	13-Nov-21
1095930	1843198	1754	13-Nov-21
1095941	1843199	1754	13-Nov-21
1095907	1843201	1747	13-Nov-21
1095908	1843202	501	13-Nov-21
1095912	1843203	501	13-Nov-21
1095913	1843204	501	13-Nov-21
1095914	1843205	501	13-Nov-21
1095916	1843207	501	13-Nov-21
1095917	1843208	1747	13-Nov-21
1095918	1843209	501	13-Nov-21
1095919	1843210	501	13-Nov-21
1095920	1843211	501	13-Nov-21
1096084	1843212	1748	13-Nov-21
1096223	1843409	1711	14-Nov-21
1096224	1843410	1711	14-Nov-21
1096226	1843411	1628	14-Nov-21
1096228	1843418	7952	14-Nov-21
1096229	1843419	501	14-Nov-21
1096231	1843421	7952	14-Nov-21
1096240	1843423	1585	14-Nov-21
1096232	1843424	1585	14-Nov-21
1096233	1843425	1651	14-Nov-21
1096261	1843426	1618	14-Nov-21
1096235	1843427	2484	14-Nov-21
1096236	1843428	1585	14-Nov-21
1096237	1843431	1585	14-Nov-21
1096238	1843432	1603	14-Nov-21
1096239	1843433	1726	14-Nov-21
1096241	1843434	1634	14-Nov-21
1096266	1843435	1757	14-Nov-21
1096244	1843436	1711	14-Nov-21
1096245	1843437	1634	14-Nov-21

Table 2

InvoiceID	Sale
1096133	1750.88
1095844	740
1095847	5140
1095850	120
1096035	3518.69
1095851	250
1096260	490
1095852	3360
1095853	1920
1095854	1980
1095855	1660
1095856	4000
1095857	1670
1095859	2014
1095860	640
1095861	1670
1095862	770
1095865	2580
1095866	1960
1095867	1980
1095869	5060
1095870	970
1095871	1890
1095872	1190
1095874	1380
1095875	1900
1095876	1380
1095877	2010
1095879	270
1095883	2060
1095885	3540
1095886	850
1095887	890
1095889	150
1095890	200
1095891	100
1095892	4040
1095893	3710
1096059	370
1095894	660
1096014	5410
1095895	1100
1095900	2370
1095897	5720
1095898	1200
1095902	2166
1095899	1640
1095939	4500
1095940	16290
1095904	990
1095905	3040
1095906	2050
1095930	1440
1095941	1645
1095907	28240
1095908	500
1095912	800
1095913	2630
1095914	2950
1095916	1670
1095917	1050
1095918	2420
1095919	1760
1095920	1530
1096084	1471.28
1096223	4020
1096224	190
1096226	200
1096228	13730
1096229	2510
1096231	1555
1096240	8950
1096232	22620
1096233	860
1096261	1212
1096235	1640
1096236	3410
1096237	22620
1096238	17595
1096239	1005
1096241	1252
1096266	1560
1096244	621.9
1096245	7875

[AlexisOlson · Accepted solution]

I think you meant

Day Sales Today = CALCULATE ( [Total Sales], 'Calendar Ultimate'[Date] = TODAY () - 1 )

[StefanoGrimaldi]

try this: 

Day Sales Today = CALCULATE([Total Sales], 'Calendar Ultimate'[Date] = TODAY())

Day Sales Prev Day = CALCULATE([Total Sales], Today()-1)

or this: 

Day Sales Today = CALCULATE([Total Sales], 'Calendar Ultimate'[Date] = TODAY())

Day Sales Prev Day = CALCULATE([Total Sales], PREVIOUSDAY(Today())

[AlexisOlson · Accepted solution]

I think you meant

Day Sales Today = CALCULATE ( [Total Sales], 'Calendar Ultimate'[Date] = TODAY () - 1 )

[gauravnarchal]

@StefanoGrimaldi - I'm getting an error

[StefanoGrimaldi · Accepted solution]

corrected: 

Day Sales Today = CALCULATE([Total Sales], 'Calendar Ultimate'[Date] = TODAY())

Day Sales Prev Day = CALCULATE([Total Sales],'Calendar Ultimate'[Date] = Today()-1)

or this: 

Day Sales Today = CALCULATE([Total Sales], 'Calendar Ultimate'[Date] = TODAY())

Day Sales Prev Day = CALCULATE([Total Sales], 'Calendar Ultimate'[Date]  =PREVIOUSDAY(Today())

[StefanoGrimaldi]

my bad missed a part of the argument add befor the today or the privious day dax a Columna date = (today()-1) 

[gauravnarchal]

@StefanoGrimaldi - In the second measure something is missing in the argument

[bernardo_elli]

Have you tried:

Day Sales Prev Day = CALCULATE([Total Sales], 'Calendar Ultimate'[Date]  =PREVIOUSDAY(Today())

?

This is what @StefanoGrimaldi told you above.