Forum Discussion

kagu's avatar
kagu
Frequent Visitor
2 years ago

Total for measure

I know many of them have a similiar problem, but the other posts do not help me. Maybe you can have alook at this:

I created two measures:

 

 

AgeingDays_Meas = 
VAR ageingDate = MIN('dwh dimDate'[Date])
VAR dueDate = SELECTEDVALUE('dwh factCustomerTransactions'[DueDate])
VAR differenz = DATEDIFF(ageingDate,dueDate,DAY)
RETURN differenz
Test = IF([AgeingDays_Meas]>0,IF([AgeingDays_Meas]<31,[AmountInEuro_Meas],BLANK()),BLANK())

 

 

Then I put them in a table:

 

I understand why there is no total for test, But is there a possiblity to have it for test?

 

Thanks in advance.

2 Replies