Matrix Visualization Issue with displaying new data.

[Phil_E]

Hi - I am developing a matrix visual to display the application availability percentage for each month. I have a slicer dropdown "Outage by Month" that a user can select a month and it will show only the rows for the month where the availability is <100%. When no month is selected all rows inluding 100% and <100% availablity for all the months are displayed. I ran into a problem, when I added a new record for the current month (Mar-25) that had 100% availability for this month and this record will not show up in the matrix, unless I add add a value of 100% in the month of Feb-25. Or I set the value to be less that 100% which is strange. The DAX code is below:

ShowRows =

VAR IsMonthSelected = HASONEVALUE('Availability Master Report'[Month])

RETURN

    IF(

        IsMonthSelected,

        -- If a month is selected, show rows where availability is less than 1

        IF(MAX('Availability Master Report'[Availability Percent]) <1, 1, 0),

        -- If no month is selected, show all rows

        1

    )

ShowRows is added to the matrix filter where ShowRows is set to 1. I appreciate any help in resolving this issue. 

[lbendlin]

To report on things that are not there you need to use disconnected tables and/or crossjoins

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...