Financial Course

DAX DAX Calculations
1

Hi guys,

I am following the Financial Course, I need to get rid of this zeros. the measures is 100 as described by Sam in the course, his table seems OK but mine produces this zeros where should be blank.!
Any idea what am I going wrong. I have tried wrapping it up with and IF (…) and I have tried BLANK() at the ned of the measure but to not avail?
Zeros|333x500 ZerosDAX

Thanks

2

Hello @FPastor,

Thank You for posting your query onto the Forum.

Could you please upload the working of the PBIX file or the mock-up file? So that members of the forum can assist you in a better and efficient manner. Without which it will just involve the guess work and will consume the time of the members.

Thanks and Warm Regards,
Harsh

3

Hi Harsh,

Sure please see attached. This is from the Financial Reporting Course.

Financial Reporting Course.pbix (594.9 KB)

Thanks and regards

Federico

1 Like
4

Hello @FPastor,

Thank You for providing the working PBIX file.

So the problem was in the base measure that you’ve created for “Income Values”. You’ve added constant into the measure as “0”. Below is the screenshot provided for the reference -

Income Values Measure With Constant

Once you remove the “0” from the measure everything gets back to normal. Below is the screenshot provided for the reference -

Income Values Measure Without Constant

Final Results
Final Results442×689 17.6 KB

I’m also attaching the working of the PBIX file for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Financial Reporting Course - Harsh.pbix (595.8 KB)

1 Like
5

Thank you very much Harsh.

I use the +0 to avoid (blank) in single value cards.

The problem is sorted and I learnt one more interesting point.

Kind Regards,

Federico

1 Like
6

Hello @FPastor,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh

1 Like