Forum Discussion
How to replace blank values by zero in matrix
I have one column amount. and i am adding measure sum(amount) in matrix. but for some row column combination it is displaying blank so i want to replace those blank with zeros. I tried measure meas...
Hi Anonymous
Try something like...
IF(
CALCULATE( COUNTROWS( YourTable ), ALLEXCEPT( YourTable, 'DateTable' ) ) > 0,
[YourMeasure] + 0
)
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
above measure is syntactically wrong.
i have modified it
total = IF(
CALCULATE( COUNTROWS('Fact Claim Lag Aggregate'), ALLEXCEPT('Lag Aggregate Paid Date','Lag Aggregate Paid Date'[Lag Aggregate Paid Date] ) ) > 0,
([Lag Aggregate Total Paid Original Amount] + 0),[Lag Aggregate Total Paid Original Amount]
)
please check and let me know, is it as per your logic?
Fact lag table
lag key
paid date key
service date key
original amount
lag aggregate paid date(dimension)
paid date key
paid date
month year
service date(dimention)
service date key
service date
month year
both dimention are connected with fact