Forum Discussion

oliverblane's avatar
oliverblane
Helper III
4 years ago
Solved

Calculated Measure that Filters Another Table with Inactive Date Relationship

Hi, this is a follow up question this post: https://community.powerbi.com/t5/Desktop/Calculated-Measure-that-Filters-Another-Table/m-p/2454962#M876616   I would like to extend the solution to handl...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    oliverblane , I check out file and tried a few versions. Can you share an example out output difference - expected vs Actual ?

     

    example

     

    Distinct Courses 1 - Using Other Date Relationship = 
var _1 = SUMMARIZE(FILTER(CALCULATETABLE( Table1,USERELATIONSHIP(Table1[Start Date], DateTable[Date])), Table1[Course Status] =1), Table1[ID])
return
CALCULATE(
    DISTINCTCOUNT(Table2[PRN]),
    Table2,
    Table2[ID] in _1
    )

     

amitchandak's avatar
amitchandak
Super User
4 years ago

oliverblane , I check out file and tried a few versions. Can you share an example out output difference - expected vs Actual ?

 

example

 

Distinct Courses 1 - Using Other Date Relationship = 
var _1 = SUMMARIZE(FILTER(CALCULATETABLE( Table1,USERELATIONSHIP(Table1[Start Date], DateTable[Date])), Table1[Course Status] =1), Table1[ID])
return
CALCULATE(
    DISTINCTCOUNT(Table2[PRN]),
    Table2,
    Table2[ID] in _1
    )