Forum Discussion

benabdillahr's avatar
benabdillahr
Frequent Visitor
4 years ago

DAX ALLEXCEPT function with RELATED table columns as filters

Hi All, I am trying to calculate the distinct count of a field "Visits" but only need it to be filtreable by a "Date" field from another table. I used the ALLEXCEPT funtion but the filter and formu...
Need Help
smpa01's avatar
smpa01
Community Champion
4 years ago

benabdillahr may be try this

 

 

CALCULATE( DISTINCTCOUNT(Visits[Visits: Visits Id]),
ALL('Date'),VALUES('Date'[Date]), ALL(Visits[Category]))

replicated on a small scale, pbix is attached

 

 

 

benabdillahr's avatar
benabdillahr
Frequent Visitor
4 years ago

Unfortunately, I get the same result ☹️

 

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    benabdillahr  please provide a sample pbix representative of the issue

    • benabdillahr's avatar
      benabdillahr
      Frequent Visitor
      4 years ago

      Hi smpa01 !

      Here is exactly what I'm looking for, i just need the date filter to come from the date table instead of the visits table.