Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help i displaying the data with filter and without filter.

Data Set: Document Date Data 5/5/2020 1 5/6/2020 3 5/23/2020 5 6/1/2020 3 6/2/2020 5 6/5/2020 2 7/1/2022 5 7/3/2020 6 Created a Cal date from table from (2010,1,1 to 2030,12,31) Joined wit...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    You can delete the realationship between calendar date and document date, create a control measure like this and set its value as 1 in the visual filter to achieve this:

    Visual control = 
VAR _max =
    CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar'[Date] ) )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Document Date] ) > _max, 1, 0 )

     

    Sample file is attached that hopes to help you, please check and try it: Need help i displaying the data with filter and without filter.pbix 

     

    Best Regards,
    Yingjie Li

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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

To do this, you typically need a disconnected table.  Here is one approach to get your desired result.

 

1. Make a calculated table with your documents date with no relationship to your original table - 

Doc Dates = VALUES(Documents[Document Date])
 
2. Make your slicer from that new column/table
 
3.  Make one measure and table with this measure
Data Sum = CALCULATE(SUM(Documents[Data]), VALUES(Documents[Document Date]), TREATAS(VALUES('Doc Dates'[Document Date]), Documents[Document Date]))
 
And another measure and table with this measure
Other Dates Sum = CALCULATE(SUM(Documents[Data]), VALUES(Documents[Document Date]), EXCEPT(VALUES(Documents[Document Date]), TREATAS(VALUES('Doc Dates'[Document Date]), Documents[Document Date])))
 
And this will be the result
 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat