Calculate the percentage of the sum of column depending a text value of other column

[Anonymous]

Hi all!

I hace tw columns:

Column 1 = USD Value

Column 2 = Text with two values

I need a measure that calculates the percentage of each USD Value of Column 1 but selecting only the rows that in Column 2 has certain text value. 

Actually I am using: 

Measure  =

//Calcula el % del FMV 

DIVIDE([Column1],

CALCULATE(Column1, ALL(General)), 0 )

I guess I would have to change the ALL Formula for a new one that includes Column2? How do I dot that and specify that I want only the calculation of Column1 only when Column1 has certain value?

Thank you!

[v-xiaotang]

Hi @Anonymous 

Not clear the result you want. You may take steps bellow for reference.

Create the measure:

Measure 2 = DIVIDE(SELECTEDVALUE('Table'[Column1]),CALCULATE(SUM('Table'[Column1]),FILTER(ALL('Table'),'Table'[Column2]=SELECTEDVALUE('Table'[Column2]))),0)

result:

Hope it helps.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[AlB]

Hi @Anonymous 

Do you want to show some sample data plus the expected result?

Your explanation is not clear

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.