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?
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
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] )
I double and triple checked and also created the visual new. But still empty
Jahr = YEAR ('Date'[Date])
Is it somehow possible to modify this?
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
SUMMARIZE ( 'Date', 'Date'[Jahr], 'Date'[Monta] ),
CALCULATETABLE ( VALUES ( 'Lost_prep'[Cliento] ) )
CROSSFILTER ( 'Date'[Date], '2_Abfrage_Orderline'[Date], BOTH )
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.