Forum Discussion
Impactful IndividualCalculated Column in DAX, if no value then...
Hi Applicable88 ,
If your data model does not have any data, it will not be displayed if you add a calculated column, you can use a measure instead.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserThis can work if you can format 'sales'[Forecast] as text
new measures ---
Forecast M = Sum('sales'['sales'[Forecast])
final measure =
if ( isblank( [Forecast M]), "TBA", [Forecast M] & "")
or better format the number using the format function
Impactful IndividualHello amitchandak ,
not working.
I think if there are no rows input into DataModell, the format () cannot format from "nothing" and also isblank cannot check for blank when rows=0. Thats what is stated in the left bottom side. zero rows.