Forum Discussion
Helper IIPower bi firstnonblank showing differently
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.
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.
Helper IIHi 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?
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.