Forum Discussion

pedroccamaraDBI's avatar
pedroccamaraDBI
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

distinctcount with crossfilter?

Hello all I would like to have just one measure to count all distinct contractID. Here is my model My main table, documents, is connected with dates with an active connection. My other table...
Need Help DAX
  • amitchandak's avatar
    amitchandak
    4 years ago

    pedroccamaraDBI , if contract and document are two fact, they should join. Or should be merged into one fact.

     

    even if the join is inactive you can use these dates filter like

     

    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = minx(allselected(Date1),Date1[Date])
    return
    calculate( distinctCOUNT(Contrcat[Contract ID]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

     

     

    if need add cross join to remove date join with document

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

pedroccamaraDBI , if contract and document are two fact, they should join. Or should be merged into one fact.

 

even if the join is inactive you can use these dates filter like

 

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( distinctCOUNT(Contrcat[Contract ID]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

 

 

if need add cross join to remove date join with document