Forum Discussion

gaiusgw's avatar
gaiusgw
Icon for Helper III rankHelper III
5 years ago
Solved

Return unique value list from date range slicer

I have used the method descibed in this link to do date range comparisons for sales but now I need to return a list based on the code.    https://medium.com/chandakamit/power-bi-comparing-data-acro...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Try to create a measure and apply it to visual level filter.

    measure = if(max(OPENDET [ORDER DATE]) in values('Date'[Date]),1,0)

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi gaiusgw 

 

Download sample PBIX file

 

The List of Unique ID's can be created with this

 

List Unique IDs = 

CALCULATE(CONCATENATEX(DISTINCT(OpenDet[CustNumber]), ('OpenDet'[CustNumber]),", "))

 

 

and the count with this

 

Count Unique IDs = DISTINCTCOUNT(OpenDet[CustNumber])

 

 

Regards

 

Phil

  • gaiusgw's avatar
    gaiusgw
    Icon for Helper III rankHelper III
    5 years ago

    Hey Phil,

    Thanks for examples and the file! However, I may has misspoke when I said "list" of unique returns. What I meant was narrowing down a table of IDs based on the date formula I am curretly using. 

     

    The count part is what I needed for count though so that great. Thanks a lot.