Most Recent Value doesn't correspond in report visual to data column

[Thomas-B-Hudson]

Hi All,

I have created a calculated column in my data model to return the latest value based on candidate ID and jobOrderID.

The calculated column is calculating as expected in my data model. However, when I bring this into my report visual, is it not calculating as expected, I am just wondering why this might be happening and if anyone can help?

You can see from my from the below that the data is working as intended with the formula's I have. 

My issue is though, when I bring this into a table visualisation, both records appear with a value of 1 in column IsLatest and I am struggling to understand why it would be doing this?

Any help would be appreciated.

Tom

[Anonymous]

Hi @Thomas-B-Hudson,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Shaurya]

Hi @Thomas-B-Hudson,

It is possible that there is some filter or slicer in your report that affecting the results that you are seeing. Try removing any filter context that is applied by using ALL or ALLEXCEPT. You can try turning off interactions.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Graphical Comparison