Forum Discussion

cmajewski's avatar
cmajewski
Frequent Visitor
5 years ago

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...
Need Help
FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
5 years ago

Hi 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's avatar
cmajewski
Frequent Visitor
5 years ago

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.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi cmajewski ,

     

    Sorry but I'm a little confused by the description,could you pls make some examples and advise me your expected output?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!