Forum Discussion
Checking file size column vs scalar not working
Hi Anonymous ,
As I understand it, for your first question, I think you are right, the legend in the bar chart is needed to calculate the columns, the metrics are not put in.
Column = IF('file_data'[File size (MB)]<='file_data'[Maximum file size (MB)],1,0)If it is the case that one calculated column works and not in another, you can check the relational model and context (including filters); you can refresh or load the dataset; and you can check that the data type is correct. If you can provide your example dataset, it might be better to help you solve the problem.
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
As I understand it, for your first question, I think you are right, the legend in the bar chart is needed to calculate the columns, the metrics are not put in.
Column = IF('file_data'[File size (MB)]<='file_data'[Maximum file size (MB)],1,0)
If it is the case that one calculated column works and not in another, you can check the relational model and context (including filters); you can refresh or load the dataset; and you can check that the data type is correct. If you can provide your example dataset, it might be better to help you solve the problem.
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.