Forum Discussion
Helper IIPower bi firstnonblank showing differently
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
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.
3 Replies
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__vHi Yongkang,
Thanks for Looking into it, I have the data below. After adding the calculationIF(FIRSTNONBLANK('Table'[Target],0)="Yes",BLANK(),SUM('Table'[Weight]))
Table LevelTarget
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?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.