Forum Discussion
DAX Measure
I have a table like this
I wan't to show total in card for rent. And currently the rent column data type is in text. so I'm unable to create measure for this. Is there any way to create measure for this column.
Hi, Anonymous
Please try the following methods.
Value = IF([Rent]="NULL",Blank(),[Rent])Is this the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Anonymous , You can change datatype to number .
or try a measure like
sumx(filter(Table, Table[Rent] <> "NULL"), [Rent]*1 )
You will want to replace the typed "NULL" with actual nulls. Then you can convert the rent field to a decimal and create your measure! You can replace the values in Power Query Editor
Hi, Anonymous
Please try the following methods.
Value = IF([Rent]="NULL",Blank(),[Rent])Is this the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
