Forum Discussion
Sub unit Total
Hello MSuser5 ,
Try using following DAX:
ALLSELECTED_measure = CALCULATE([Count]),ALLSELECTED([Sub_Unit])ThanksIf this helps, mark this as a solution!!Heu MSuser5
Input:
Please create the following measureSub_unit Total = CALCULATE(SUM(TableA[Count]), ALLEXCEPT(TableA,TableA[Sub_Unit]))
And Plot the table and you will get the expected output:
If this helps you then please mark my solution as accepted so that others can find it quickly when they face the similar issue. Thank you!
Hi, MSuser5
From the picture, I get that you have three columns right? and last column has text and number mixed and you want to sum the numbers.
here is the suggestation.
1. go to power query.
2. split the last column
here is the documentation for you. https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
after split, you will have 2 columns. rename with your own choise.
sum it up or visualize it in a table.
so, you can not split the column? it is your requirement?