Forum Discussion
Fernus
6 years agoFrequent Visitor
Starting out in Power BI, Need DAX help
Hi, I'm new to Power BI and almost pulling my hair out as I come across multiple DAX issues in trying to create new measures! To start with can someone tell me why this formula will not work?...
Fernus
6 years agoFrequent Visitor
AlB After getting rid of a column which had a load of errors in it a value started to appear on the card with your formula but it is summing all the values in that column up instead of summing it distinctly ie 819 instead of 219 like in yours. Lord knows why it is working for you but not me? :smileymad:
Could it be because there are other columns are in the dataset which I have not mentioned as they are not relevent to this query? Your cost formula worked a treat however!
Nathaniel_C whatever works but I understand creating measures instead of columns wherever it can be helped is a better approach