topic Re: Total of dax measure is blank, but it generates results in a table visual in DAX Commands and Tips

Total of dax measure is blank, but it generates results in a table visual

Commons94 — Fri, 21 Jul 2023 11:08:45 GMT

the above shown code is my dax measure. This measures produces values for the respective BelegXPos when I use it in a table but doesn't show the grand total in the table and also shows up a blank when I use it in a 'Card' visual. Do you guys have any idea why could it be so..? Sample dataset is given below. Thanks a lot in advance.

BelegXPos	BUDAT	WE	BTE Menge0
A	09/09/1911	183	364
B	16/05/1924	171	147
C	18/09/1910	194	367
D	15/03/1920	109	215
E	24/03/1923	172	287
F	20/07/1920	150	341
A	19/08/1926	127	152
B	29/08/1925	170	340
C	19/11/1919	183	335
D	10/03/1922	154	136
E	19/08/1921	142	319
Total		1755	<Blank>

Re: Total of dax measure is blank, but it generates results in a table visual

mlsx4 — Fri, 21 Jul 2023 11:30:23 GMT

Maybe you just need to add a SUMX

BTE Menge1= SUMX('Table',[BTE Menge0]) //or use SUMX (VALUES(Table[DAT]),[BTE Menge0]) if you try to sum by date

Re: Total of dax measure is blank, but it generates results in a table visual

Commons94 — Fri, 21 Jul 2023 14:20:54 GMT

mlsx4 thanks for your reply. I did try working with SUMX function and its giving me a result and not blank.... the problem now is that I'm comparing 3 scenarios like the following:

1st scenario: where BTE_Termin = budat

2nd scenario: where BTE_Termin - budat <=1, for which I'm using the following code:

3rd scenario: where BTE_Termin - budat <= 2, for which the following code is being used:

but SUMX seems to give me the same answer for all 3 scenarios. instead the BTE MengeX (result column in red: see table in 1st question) should be different for different scenarios. the measures are giving me different BTE Menge in table visual but not in a card or chart.

hope you can understand the issue. thanks!

Re: Total of dax measure is blank, but it generates results in a table visual

mlsx4 — Mon, 24 Jul 2023 06:44:47 GMT

Hi Commons94

Yes, I understand the issue. And if you add a condition? Something similar to:

If (selectedvalue(BelegX)="", menge0+menge1+menge2)

Re: Total of dax measure is blank, but it generates results in a table visual

Commons94 — Mon, 31 Jul 2023 12:39:44 GMT

thanks for your reply. It didn't work. So I duplciated the tables and worked it out through 'Group by' function in Power Query.

PS: sorry for the late reply.