Forum Discussion
Serious problem with calculated column
Hi Anonymous ,
use your measures for visuals not for calculated columns.
PBIX-file is attached.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Please post a data sample (not a picture).
Here,
https://drive.google.com/file/d/1ZwMjm0-pT_5jcvEyDqRFQdZqShqe_2Jr/view?usp=sharing
You can find the pbix file.
If [b] and [m] replaced with the actual values you can see on the Report view, the values shows normally.
Well, knock me down with a feather,
I've just answered a forum question where someone was using measures in a calculated column. I don't recommend it.
Replace it with the appropriate DAX. At least you'll be able to debug any formulas a bit easier.
In your case, the measure [m] is 0 or unknown in the context of this calculated column.
Hi Anonymous ,
use your measures for visuals not for calculated columns.
PBIX-file is attached.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)