Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm fairly new to Power BI and have found so much help on this site thank you!
I have a matrix visual that works fine in Desktop view, but exceeds memory usage when I publish it to app.powerbi.com (Since I usually work in Desktop - I'm not sure in which group to put my question)
The visual shows the "campaign revenue" for a few products in each their specific time period (their "campaign period").
I have a supporting small excel file with the SKU, start date ('kampagnemaal'[Startdato]), end date('kampagnemaal'[Slutdato]).The dates are different for each product:
My measure for works fine in desktop, but is veeeery slow. I need specific tips for changing my data or DAX to get below 1024 mb ram.
Current measure:
Since the dates are only for this year, I tried filtering my data ('fact Værdiposter (Value Entry)'[Sales Amount (Actual)]) in powerquery to only show this year, but that made no visible difference.
I found out that my problem might be that "filter" is not the right way to go, but can't figure out which way to go then? 🙂
Hopefully, you can help!
Thank you,
Theresa
Solved! Go to Solution.
@Thefae
Can you try this version please:
Omsætning kampagneperiode =
var __Startdato = MIN ( 'kampagnemaal'[Startdato] )
var __Slutdato = MIN ( 'kampagnemaal'[Slutdato] )
return
CALCULATE (
SUM ( 'fact Værdiposter (Value Entry)'[Sales Amount (Actual)] ),
FILTER (
all('Date'),
'Date'[Date] > __Startdato && 'Date'[Date] < __Slutdato
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Only 3 🙂 Fowmys re-writing of my measure worked 🙂
@Thefae
Can you try this version please:
Omsætning kampagneperiode =
var __Startdato = MIN ( 'kampagnemaal'[Startdato] )
var __Slutdato = MIN ( 'kampagnemaal'[Slutdato] )
return
CALCULATE (
SUM ( 'fact Værdiposter (Value Entry)'[Sales Amount (Actual)] ),
FILTER (
all('Date'),
'Date'[Date] > __Startdato && 'Date'[Date] < __Slutdato
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
That worked perfectly, thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |