Forum Discussion

r_power12's avatar
r_power12
Advocate I
10 years ago
Solved

Can't Display the Visual

I have a Power BI Desktop model uploaded to Power BI (app.powerbi.com) using a Pro account, all latest versions as of May 4, 2016. The reports in Power BI worked fine for 1-2 weeks; however recently,...
Need Help
  • r_power12's avatar
    r_power12
    10 years ago

    After diving a bit deeper, I discovered the issue only affected some of my measures which required syntax changes as the example below shows:

     

    From

    Measure 1 = CALCULATE(COUNTROWS())

     

    To

    Measure 1 = CALCULATE(COUNTROWS(Table1))

     

    It appears the latest update of Power BI (app.powerbi.com) now requires the table name as a parameter of the COUNTROWS() function. 

     

     

     

     

     

r_power12's avatar
r_power12
Advocate I
10 years ago

ankitpatira I am using import data, sql queries pulling from an on-premise database.

 

The data loads and displays fine in Power BI Desktop, but the visuals present the error online in app.powerbi.com.

r_power12's avatar
r_power12
Advocate I
10 years ago

After diving a bit deeper, I discovered the issue only affected some of my measures which required syntax changes as the example below shows:

 

From

Measure 1 = CALCULATE(COUNTROWS())

 

To

Measure 1 = CALCULATE(COUNTROWS(Table1))

 

It appears the latest update of Power BI (app.powerbi.com) now requires the table name as a parameter of the COUNTROWS() function.