Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 as well as be able to get the count of each as also get the % based on of all the values in the column.
I have tired creating a column and then assigning numbers to these text values, but there are a lot of different values so it would make it too long. What I could do is assign values to the MC, EP, NH, & RV and then all others are one value. But I don't know how to write that or how I would be able to get it to calculate the proper total if I am assigning values?
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)
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.
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!
Okay I see. Although what I want to do is take MC+EP-NH+RV = value
Then take that value and give me the % for all the values in the column as there are others, like COCL1, HUCL1, etc.
Also this data is already in a column called "Placement Ops" so where you have table do I put Count = Count('Table''[Placement Ops]?
User | Count |
---|---|
82 | |
76 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |