Measure is Turning Blank on Table

vkisa — Fri, 09 Feb 2024 08:27:30 GMT

Hi,

I can calculate the diagonal values according to 2 different dates, but my aim is that create this measure for a matrix with row "customer" and one of the dates.

Here is the sample data,

StartYear	StartMonth	CalcYear	CalcMonth	Customer	fixedfee
2023	1	2023	1	100	0.00
2023	1	2023	2	100	0.00
2023	1	2023	3	100	0.00
2023	1	2023	4	100	0.00
2023	1	2023	6	100	0.00
2023	1	2023	7	100	41.07
2023	1	2023	8	100	115.93
2023	1	2023	9	100	62.23
2023	3	2023	3	100	0.00
2023	3	2023	4	100	0.00
2023	3	2023	6	100	0.00
2023	3	2023	7	100	41.07
2023	3	2023	8	100	57.97
2023	5	2023	5	100	0.00
2023	5	2023	11	100	77.95
2023	6	2023	6	100	0.00
2023	6	2023	7	100	82.13
2023	6	2023	12	100	100.88
2023	6	2024	1	100	131.92
2023	7	2023	7	100	1,190.93
2023	7	2023	8	100	289.83
2023	7	2023	9	100	248.93
2023	7	2023	10	100	329.81
2023	7	2023	11	100	155.91
2023	7	2023	12	100	403.53
2023	7	2024	1	100	263.85
2023	8	2023	8	100	1,681.03
2023	8	2023	9	100	622.33
2023	8	2023	10	100	329.81
2023	8	2023	11	100	311.82
2023	8	2023	12	100	201.76
2023	8	2024	1	100	263.85
2023	9	2023	9	100	1,867.00
2023	9	2023	10	100	593.65
2023	9	2023	11	100	77.95
2023	9	2023	12	100	302.65
2023	9	2024	1	100	131.92
2023	10	2023	10	100	1,715.00
2023	10	2023	11	100	467.73
2023	10	2023	12	100	201.76
2023	10	2024	1	100	131.92
2023	11	2023	11	100	1,715.00
2023	11	2023	12	100	201.76
2023	11	2024	1	100	395.77
2023	12	2023	12	100	1,715.00
2023	12	2024	1	100	263.85

The measure that calculates the diagonal values below, turns blank on the matrix when "customer" is on row and "calcdate" is on column,

FF_Agg = VAR startyear=SELECTEDVALUE(table[StartYear]) VAR startmonth=SELECTEDVALUE(table[StartMonth]) RETURN CALCULATE ( SUM(table[FixedFee]), FILTER(table,startyear=table[CalcYear] && startmonth=table[CalcMonth]) )

It will be dynamic table under the date filters so, I need a measure instead of calculated table, my aim matrix to reach out,

	CalcYear	2023
Customer	CalcMonth	1	2	3	4	5	6	7	8	9	10	11	12
100		0	0	100	0	100	100	1190	1681	1867	1715	1715	1715

Thank you,

Veli

Re: Measure is Turning Blank on Table

Anonymous — Fri, 09 Feb 2024 06:43:38 GMT

Hi vkisa ,
You seem to be trying to calculate the diagonal values of a matrix where the rows represent customers and the columns represent dates. What is the result you expect to arrive at, and are the blank values of the matrix also shown? Can you clarify your question or provide more information about what you are trying to accomplish?

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Measure is Turning Blank on Table

vkisa — Fri, 09 Feb 2024 08:29:39 GMT

I've updated the post, the measure that I have tried is working when when two dates and customer are included on the table, but I need a matrix with customer is on roe and calcyear/month is on column.

topic Re: Measure is Turning Blank on Table in DAX Commands and Tips

Measure is Turning Blank on Table

Re: Measure is Turning Blank on Table

Re: Measure is Turning Blank on Table