Financial Dashboards

DAX DAX Calculations
1

I went through the Financial Dashboards videos and tried to do replicate the file on my own. I faced the following issues, and appreciate any guidance:

  1. Double Calculate instead of LY value:
    In the video called Time Comparison calculation, at min 6:53, it is said that instead of doing a double CALCULATE function, we can use one CALCULATE with the LY measure. I’ve used![1. One CALCULATE with LY measure this approach, which seemed more ‘natural’ (as shown in the print screen called ‘One CALCULATE with LY measure’), but the measure returned zeros (as shown in the print screen called ‘zeros’).

  2. Blank rows when iterating the Normalized template:
    I could not get blank values in the blank rows of the Normalized template (i.e. row index 5), without adding the following to the DAX main calculation (as shown in the print screen called ISBLANK) :
    ISBLANK(SelectedRow), BLANK()
    I noticed that you do not add a similar provision in your formula even though the measure returns a blank; is there any setting I am missing?
    Similarly, how do you get blank values under the % lines of TY vs LY (my measure returns zeros, as shown in the print screen called 0 Values in TY vs LY)

  3. TY vs LY % measure returning 0
    My TY vs LY % measure is returning a zero for all line items expect for the %s. I’ve attached two print screens and my power bi file for reference.

Thank you for your help
Regards
Charbel

1. One CALCULATE with LY measure
1. One CALCULATE with LY measure1366×768 201 KB
2. Zeros
3. ISBLANK
3. ISBLANK1366×768 221 KB
4. 0 Values in TY vs LY
5. TY vs LY % measure
5. TY vs LY % measure1366×768 241 KB
6. TY vs LY % measure returning 0 Giving it a try.pbix (749.4 KB)

2

Hi @dotbuilt, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformated text </>.

  • Use the proper category that best describes your topic

  • Provide as much context to a question as possible.

  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.

3

I had a quick look at this.

  1. Looks like PY actuals works on your demo?

image
image1161×511 41.7 KB

  1. This just looks like a formatting issue

image

this part above seems to be missing from your TY vs LY measure

image
image922×346 29.2 KB

  1. Again this looks simply like a formatting issue in your formula.

image
image1031×375 32.7 KB

Currently the formula doesn’t know that the values need to be a percentage

You’ll see here below in this image from the video that your formula setup is different to the example

image
image1229×744 246 KB

You need to make sure you can turn the format of the formula into a percentage.

image
image805×405 28.5 KB

Currently because of the above you can’t do that.

Try these things I’ve mentioned above.

Thanks
Sam

4

Hi @dotbuilt, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!