New table is not populated correctly

[Sop]

Initially I have 2 tables, contacts and cases. 1:N connection.
I have 2 measures (year('Year' ) and quarter('q' ))
They are entered on the card.
I create a new table filtering contacts using this formula
 

 
Unduplicated Contacts = FILTER (
         contact
        ISEMPTY(
             FILTER (
                 fw_case,
                  (fw_case[fw_starttime].[QuarterNo] = q[q Value] &&
                  fw_case[fw_starttime].[Year] = 'Year'[Year Value]) &&
                   fw_case[fw_contact] = 'contact'[contactid]
             )) = FALSE() && ISEMPTY (
             FILTER (
                 fw_case,
                  (fw_case[fw_starttime].[QuarterNo] < q[q Value] &&
                  fw_case[fw_starttime].[Year] < 'Year'[Year Value]) &&
                   fw_case[fw_contact] = 'contact'[contactid]
               ) ) = TRUE()
        
) 

But I am receiving incorrect data.
There are data in measures (they are used in other views and for clarity they are displayed on the canvas
If I enter static data into a formula (for example, 2021 for the year and 3 for the quarter), then the table is filled in correctly.

I'm just getting started with POWER BI

[Sop]

I tried to enter the values of measure "year" into the column and got empty. If through SelestedValue - it’s completely empty. As I understand it, this is why my table is not calculated. Tell me how can I bypass this or what should I do?

[Anonymous]

Hi @Sop 

You can check if your measure [year] is a null value, and you can check by creating a card like this:

Maybe can share your data (excluding sensitive information) or create sample data, and give us a detailed description of your needs so we can help you better.

How to Get Your Question Answered Quickly - Page 13 - Microsoft Fabric Community

Best Regards,

Zhengdong Xu

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