Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

performance problem March Release

Hello,   I'm noticing that I'm having a lot more delays on page shifting on the desktop with the March release. I'm planning on downgrading shortly, but didn't know if anyone had experienced it and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

1. neither. I cannot use live connection I don't even know what that is. They are Imports. Note: if this is connecting to a published Power BI Service Datasource, that is not even an optionfor me.

2. I cannot go too far backwards so I cannot determine that as i get warnings indicating that i've built querys using a later version and it may not work completely.

3. I don't know how to define complex in terms of DAX, but I generally only do a few if statements to make sure (blank) doesn't show up in cards.

 

edhans's avatar
edhans
Community Champion
6 years ago

You might try uninstalling, rebooting, and reinstalling. I've not seen anyone else report this. As to your IF statements, assuming you are on the March 2020 or later, you can replace IF with COALESCE and it is a bit easier.

 

Old way:

Record Count =
IF (
    COUNTROWS ( 'Table' ) = BLANK (),
    0,
    COUNTROWS ( 'Table' )
)

New way: 

Record Count =
COALESCE( COUNTROWS ( 'Table' ) ,0)

 

COALESCE() simply returns the first non-blank result in its list.