Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |