Power bi firstnonblank showing differently

[Anusha__v]

Hi,
Power bi first nonblank is used if condition in power bi service is showing values ever as in local I am getting 0.
The dashboards are the same in Local and Service.
Calculation Measure used

Test =

VAR Value1=IF(FIRSTNONBLANK(ABC[Target],0)="YES",0,sum(ABC[Weightage]))

RETURN

Value1

[Anonymous]

Hi, @Anusha__v 
Based on your information, I create a sample table.

If you want to calculate the sum of the measure only if it is Yes, you can try the following DAX:

Measure = IF(FIRSTNONBLANK('Table'[Target],0)="Yes",BLANK(),SUM('Table'[Weight]))

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anusha__v]

Hi Yongkang,
Thanks for Looking into it, I have the data below. After adding the calculation 

 IF(FIRSTNONBLANK('Table'[Target],0)="Yes",BLANK(),SUM('Table'[Weight]))

Table Level

Target	Weightage
YES	85
YES
YES	85
YES	85
YES	15
YES
YES	85

In Local/Powerbi Desktop

Target	Weightage
YES
YES
YES
YES
YES
YES
YES

in Power bi Service

Target	Weightage
YES	85
YES
YES	85
YES	85
YES
YES
YES	85

With the same measure why it's showing Differently results in Local compared to Power Bi Service?

[Anonymous · Accepted solution]

Hi, @Anusha__v 

Sorry, I misunderstood your question at first.

I created a new column index, avoided automatic aggregation of views and tested their differences between desktop and service. At the same time, I created a measure and a calculated column to compare, using the case of 0. Because in the case of a measure or calculated column that results as a null value, the view automatically aggregates and doesn't show anything.

In desktop:

In service:

After testing, they are not different.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.