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 wonder if this Measure can be optimized a bit? I works as intended, but is a bit slow
Seneste betalingsmetode =
VAR SenestBetalt = CALCULATE(
MAX(FactBetalingslinjer[DatoKeyStoettePeriode]),
FactBetalingslinjer[#Payed Amount (GL)] > 0
)
VAR BetaltMetode = CALCULATE(
MAX(FactBetalingslinjer[BetalingsmetodeKey]),
FactBetalingslinjer[DatoKeyStoettePeriode] = SenestBetalt
)
VAR Metode = CALCULATE(
MAX(DimBetalingsmetode[BetalingsmetodeNavn]),
DimBetalingsmetode[BetalingsmetodeKey] = BetaltMetode
)
RETURN
Metode
I need to find the latest period based on latest payment (Variable SenestBetalt)
Then from that date I like to find the payment type (Variable BetaltMetode)
Finally I get the paymeny name from the dimension (Variable Metode)
The final part is needed (I think) because it's a starschema with all dimensions pointing at FactBetalingslinjer, so I can find the key and then get the name from the dimension.
But can it be done smarter? and can it be done faster.
Thanks in advance 🙂
Hi @Bokazoit I do not understand you table name except that Fact* your fact table. If so, use ADD( SUMMARIZE pattern as variable and after that filter results.
Proud to be a Super User!
Hi @Bokazoit I do not understand you table name except that Fact* your fact table. If so, use ADD( SUMMARIZE pattern as variable and after that filter results.
Proud to be a Super User!
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |