Unable to get latest data on visual untill applying a filter

[Karolina_Sliwa]

Hello, I would be grateful if you can help me or at least point out on what am I doing wrong: 

I have a data with customer requirements number and statuses however when I apply in filter that is should take data from latest avilable date it is showing properly: 

When I remove this filter it is showing me all the statuses one requirement had in the past so it is counting it more than one time: 

I count the number with this measure: 

Customer Requirements =

CALCULATE(

    DISTINCTCOUNTNOBLANK('Customer Requirements 2'[Requirement Customer Id]),

    FILTER('Customer Requirements 2', 'Customer Requirements 2'[Date]= [Last Available Date]))

In Y axis I am providing this measure nad X-axis the status (Compliance form my available data in sheet).



How to define this data to have them accroding the latest avilable date but not having to add this Date in the filters?


For my files I am adding new files each weekw with a date to have a history becuase I need to see a progress in time also (in other visuals).

[shafiz_p]

Hi @Karolina_Sliwa  As I can understand that you want to show requirements for latest date and also have the ability to use custom date.

It is better to provide representative data and desired output to get the exact solution.

However, If this is the case, you could try this:

Customer Requirements =

VAR _LatestOrSelected =
IF(
  ISFILTERED('Customer Requirements 2'[Date]),
  SELECTEDVALUE('Customer Requirements 2'[Date]),
  MAX('Customer Requirements 2'[Date])
)

RETURN
CALCULATE(
    DISTINCTCOUNTNOBLANK('Customer Requirements 2'[Requirement Customer Id]),
    FILTER(
         'Customer Requirements 2', 
         'Customer Requirements 2'[Date]= _LatestOrSelected
    )
)

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[MFelix]

Hi @Karolina_Sliwa ,

If you have information from other dates you always need to have the filter for the specific date you want, this can be done in two ways, you can add the filter context on the measure has you did, and use that measure for that specific visual, or add the filter to the visual itself in the filter pane to only get the latest date.

For that specific visual you will need to change the filter context for the measure in one of the two ways described.

[Karolina_Sliwa]

Hi, thanks for an answer. 

I already have added filter on this measure Customer Requirements takingin to consideraiton latest available date, however if I am adding on the visual Compliance(status) of those requirements it is showing me more requirements than in the latest data - like it showing e.g. Completed, In-Porgress status for one requirements as in teh past the status was differtn, so it look like frot hose statuses I do not have filter context? Something like this.. 

[Anonymous]

Hi @Karolina_Sliwa 

Please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided. So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.