Blank results for Power BI measures

[JorgeAbiad]

Hello PBI Experts,

I created the following measures  and no errors are shown.

However, theses measures are giving blank results.

Below are the measere:

 1. LVPF 66M = SUMX(FILTER('LVPF66 7M_Sheet','LVPF66 7M_Sheet'[LVPF Type]="Bud Rev incl Adj 2020 BFI"),'LVPF66       7M_Sheet'[Value]))/1000

 2. Sum LVPF in pcs = SUMX(FILTER('LVPF66 7M_Sheet','LVPF66 7M_Sheet'[LVPF Type]="Monthly LVPF 2020 Baseline"),'LVPF66 7M_Sheet'[Value])/1000000

 3. Sum LVPF in k pcs = SUMX(FILTER('LVPF66 7M_Sheet','LVPF66 7M_Sheet'[LVPF Type]="Monthly LVPF 2020 on adapted Scenario"),'LVPF66 7M_Sheet'[Value])/1000000

Below is a screenshot of my datasource. This is an Excel file stored in Sharepoint. Other measures created from other tables do not give blank results.

Please help.

Regards, 

JorgeAbiad

[amitchandak]

@JorgeAbiad , The formula seems right.  But there can issue or white space or some other filter .

Also, all the formula are divided with a number bigger than their value  , so try like

LVPF 66M = SUMX(FILTER('LVPF66 7M_Sheet','LVPF66 7M_Sheet'[LVPF Type]="Bud Rev incl Adj 2020 BFI"),'LVPF66 7M_Sheet'[Value]))/1000.0

Change all denominator to decimal with .0

Or change the Date type value to decimal

[JorgeAbiad · Accepted solution]

Hi @amitchandak ,

Thank you very much for your prompt response.

However, I changed the LVPF Type values to shorter strings and it solved the issue.

Regards,

JorgeAbiad

[v-deddai1-msft]

Hi @JorgeAbiad ,

I'm glad you solved your problem and shared the solution. Would you please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai