I have two tables that I need to use in this measure
- Invoice Fees: Stores all invoiced activities
- Reasons: Stores any codes entered against an activity to explain why an activity may have been completed late. An activity can have many reasons.
If an activity is recorded as being late, there will be some instances where the late flag will still be shown as False/No. In this example a U reason assigned against an activity will mean that it is not classed as late.
To start I created a measure in Invoice Fees to return the count of U codes for the activity where the activity was late.
Late With U Code = CALCULATE(COUNT(Reasons[LedgerLineId]),FILTER(Reasons,Reasons[Reason Letter]="U"),FILTER('Invoice Fees','Invoice Fees'[Late] = 1))
This measure works and returns the count but now results in the report refresh taking a long time.
If I create a new measure to look at this or even just wrap this in an if statement like this
Late With U Code = If(CALCULATE(COUNT(Reasons[LedgerLineId]),FILTER(Reasons,Reasons[Reason Letter]="U"),FILTER('Invoice Fees','Invoice Fees'[Late] = 1))>0,"No","Yes")
Then the report will just timeout refreshing
This would seem like it's something really simple as I have written much more complicated measures and not had this problem. Can anyone offer any help?
