Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Non Filtered Data

Hello Everyone, I am working on a dataset. When I choose a date range through a filter, I am seeing filtered data which is ok. But I need to see data which is not filtered.   Example: There are 5 ...
Interesting Links
Need Help
Show and Tell
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Piyush,

     

    We need a new independent date table in this scenario. Please check out the demo in the attachment.

    1. A date table. No relationship with other tables.

    Calendar = CALENDAR(date(2018,4,1),date(2018,4,30))

    2. A measure.

     

    Measure =
VAR selectedUsers =
    CALCULATETABLE (
        VALUES ( Table1[User] ),
        FILTER (
            ALL ( Table1 ),
            Table1[DateWorked] = SELECTEDVALUE ( 'Calendar'[Date] )
        )
    )
RETURN
    IF (
        MIN ( Table1[User] ) IN selectedUsers
            && MIN ( Table1[DateWorked] ) = SELECTEDVALUE ( 'Calendar'[Date] ),
        1,
        IF ( NOT MIN ( Table1[User] ) IN selectedUsers, 1, BLANK () )
    )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    3. Filter out the blanks.

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Piyush,

 

We can achieve a similar result. But it depends on your data structure. Can you share a sample of your data, please?

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey Dale,

    Thanks for replying. Here's my sample data:

     

     

     

    Now in visualisation when I filter date 07-Apr-18, I will be seeing users 'A' and 'B' details. But I want details of 'C' also.

    Object :  'C' didn't worked on 7-April-18 .

     

    Let me know if you need more details.

     

    Thanks and Regards,

    Piyush 

     

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Piyush,

       

      We need a new independent date table in this scenario. Please check out the demo in the attachment.

      1. A date table. No relationship with other tables.

      Calendar = CALENDAR(date(2018,4,1),date(2018,4,30))

      2. A measure.

       

      Measure =
VAR selectedUsers =
    CALCULATETABLE (
        VALUES ( Table1[User] ),
        FILTER (
            ALL ( Table1 ),
            Table1[DateWorked] = SELECTEDVALUE ( 'Calendar'[Date] )
        )
    )
RETURN
    IF (
        MIN ( Table1[User] ) IN selectedUsers
            && MIN ( Table1[DateWorked] ) = SELECTEDVALUE ( 'Calendar'[Date] ),
        1,
        IF ( NOT MIN ( Table1[User] ) IN selectedUsers, 1, BLANK () )
    )

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      3. Filter out the blanks.

       

      Best Regards,

      Dale