Forum Discussion
cmajewski
5 years agoFrequent Visitor
Calculate text values in a single column
So what I want to do is some basic math with a column. I want to take the following text values: MC+EP-NH+RV that are in a single colum, and want to be ablet calculate it basd on that expression a...
FrankAT
Community Champion
5 years agoHi cmajewski
is this what you are looking for? Here are some basic calculations:
Count = COUNT('Table'[Data])
% Percentage = DIVIDE([Count],CALCULATE([Count],ALL('Table')))
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
cmajewski
5 years agoFrequent Visitor
I was able to create the count measure without issue. Howver,I stil cannot get how to do do the basic math by subtracting and adding values in the column.