March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
because my "Lost_amount"
But depending on how many customers (=CYname) it summarizes differently.
Correct for one customer:
Something else instead of Total for more customers. (It is not even the average. No clue what it is summarizing)
Some ideas how this can be fix?
Thanks
Hi, thanks for your help again 🙂
I thought it works, but then I continued all night and now it is empty again. The columns did not change, the relationships did not change. I can't immagine why your code does not work not. So build up on your idea I used the summary table, which is now called "Lost_amount3", but this summarizes strange
@lost_flower
This way should work
Lost_new =
SUMX (
SUMMARIZE (
'6_Lost',
'6_Lost'[StartDate],
'6_Lost'[EndDate],
'6_Lost'[Product],
'6_Lost'[CYname],
'Date'[Jahr],
'Date'[Monat]
),
[Last_Sales]
)
This is empty too. Or do I have to add this code in front of something?
These are all codes I used in the visual
@lost_flower
Try to have Jahr and Monat as real columns in the Date table and use them in the table visual and in the SUMMARIZE
do you mean like that?
I did change it in the visual too, but Lost_new is still empty
Would you please double check that these are the same columns that are used in the table visual one by one?
I double and triple checked and also created the visual new. But still empty
where
Jahr = YEAR ('Date'[Date])
Is it somehow possible to modify this?
The customers are coming from a table, that selects column from table
relationships are:
Please try
Lost_amount3 =
SUMX (
CROSSJOIN ( VALUES ( 'Date'[Monta] ), VALUES ( 'Lost_prep'[Cliento] ) ),
[Lost_amount]
)
Hmmm, now it summarizes, but it has the wrong amount. Lost_amount should be the same as Lost_amount3
@lost_flower
Please try
Lost_amount3 =
SUMX (
GENERATE (
SUMMARIZE ( 'Date', 'Date'[Jahr], 'Date'[Monta] ),
CALCULATETABLE ( VALUES ( 'Lost_prep'[Cliento] ) )
),
[Lost_amount]
)
It summarized too much. So, I thought it would be better with a filter
but even this does not change something. The total still not a summary
Is this a relationship issue?
Not sure to be honest. Please try
Lost_amount3 =
SUMX (
GENERATE (
SUMMARIZE ( 'Date', 'Date'[Jahr], 'Date'[Monta] ),
CALCULATETABLE ( VALUES ( 'Lost_prep'[Cliento] ) )
),
CALCULATE (
[Lost_amount],
CROSSFILTER ( 'Date'[Date], '2_Abfrage_Orderline'[Date], BOTH )
)
)
Lost_amount3 does not match with Lost_amount. DAX seems to be very complicated
@lost_flower
It is better to connect and have a direct look at the data. Let me know if this is possible perhaps tomorrow noon Dubai time.
Oh this would be so great. How can we connect?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
62 | |
30 | |
25 | |
22 | |
17 |