Grand total of measure is blank

Commons94 — Fri, 21 Jul 2023 08:02:00 GMT

Hello community,

I tried to write a measure to get the BTE1 column as my result. The problem is that I'm not getting the total for this column. the total is always a blank. I tried using this measure on a card or graph, everything seems to be blank but yet there are values in this measure when used in a table. The sample data is given in the table below:

My measure is:

BTE Menge1 =

var last_Call = MAX('Data'[Call])

var Receipt= MAX('Quantity'[Receipt Nr.])

var Date= MAX('Quantity'[Date])

Return

CALCULATE(SUM('Data'[qty]),'Data'[Receipt Nr.]=Receipt,'Data'[Date] IN {Date-1, Date, Date+1}, 'Data'[Call]=last_Call)

Recipt Nr.	Date	WE	BTE1
ABCD_10	20/04/2022	170	170
EFGH_10	15/07/2022	66	66
IJKL_10	28/07/2022	300	300
LMNO_10	31/10/2022	100	100
PQRS_10	31/10/2022	880	880
TUVW_10	04/08/2022	154	154
XYZA_10	11/11/2022	3000	3000
BCDE_10	10/03/2023	1650	1650
Total		6320

As info: the 2 tables are connected with a master data with receipt Nr. as key.

can you guys please help me out and provide a solution as how to I can make the total on the BTE1 column visible? thanks a lot in advance!

Re: Grand total of measure is blank

lbendlin — Sun, 23 Jul 2023 21:06:22 GMT

Remember that for the Grand Total "MAX" has a different meaning. You likely need to use MAXX instead, or whatever is appropriate for your scenario

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic Re: Grand total of measure is blank in DAX Commands and Tips

Grand total of measure is blank

Re: Grand total of measure is blank