Forum Discussion
luxpbi
Helper V
8 years agoPower BI Desktop Extremely Slow
Hi, The fact is that I have a not very big pbix. It's 32MB size. I've create a calculated column, a little bit complex, but it works. The problem is that since then the pbix is extremely slow, for...
luxpbi
Helper V
8 years agoHi v-piga-msft,
They are not similar, here I'm asking why Power BI get a lot of time working on it when I select to create a new measure.
What is he doing there? Why a complex or not optimized DAX Measure or Column will afect that?
For me there is no reason for that.
In the other, I'm asking for a tool that can measure the performance of different DAX measures.
Kumail I can't share the pbix file for security reasons but I can share with you the formula:
Days =
VAR CurrentProduct = 'Table1'[Product]
VAR CurrentState = 'Table1'[Status]
VAR CurrentDate = 'Table1'[Date]
VAR CurrentNMov = 'Table1'[Index_]
VAR CurrentCodTaller = 'Table1'[Type]
VAR NextStateDate =
CALCULATE (
MIN ( 'Table1'[Date] );
FILTER (
'Table1';
'Table1'[Product] = CurrentProduct
&& ( 'Table1'[Status] <> 8
|| 'Table1'[Status] <> 9 )
&& 'Table1'[Date] >= CurrentDate
&& 'Table1'[Index_] > CurrentNMov
&& (
'Table1'[Type] <> CurrentCodTaller
|| 'Table1'[Type] = BLANK ()
|| 'Table1'[Type] = CurrentCodTaller
)
)
)
VAR LastMov =
CALCULATE (
MIN ( 'Table1'[Date] );
FILTER (
'Table1';
'Table1'[Product] = CurrentProduct
&& 'Table1'[Date] >= CurrentDate
&& 'Table1'[Index_] > CurrentNMov
)
)
RETURN
IF (
CurrentState = 8
|| CurrentState = 9;
IF (
ISBLANK ( LastMov );
( TODAY () - CurrentDate )
+ 1;
IF ( ISBLANK ( NextStateDate ); 1; ( NextStateDate - CurrentDate ) + 1 )
)
)
Regards,
Kumail
Impactful Individual
8 years agoOkay. Could you send sample dummy data as well?