Dynamic Ratio creator

Is this ok ?  

For your reference.

Step 0: I use these DATA below.

Step 1: I make two tables and four measures below.

 <Tables>

    Field01 = SUMMARIZE('DATA','DATA'[Field])

    Field02 = SUMMARIZE('DATA','DATA'[Field])

 

<Measures>

Field01_Sel = SELECTEDVALUE(Field01[Field])

Field02_Sel = SELECTEDVALUE(Field02[Field])

value Sel = SUMX(FILTER('DATA','DATA'[Field]=[Field01_Sel]),'DATA'[value])+SUMX(FILTER('DATA','DATA'[Field]=[Field02_Sel]),'DATA'[value])

Ratio = DIVIDE(SUMX(FILTER('DATA','DATA'[Field]=[Field01_Sel]),'DATA'[value]),SUMX(FILTER('DATA','DATA'[Field]=[Field02_Sel]),'DATA'[value]))

 

Step 2: I make two slicers and a matrix below.

<Ratio=A/C>

 <Ratio=E/A>

 

Hi izzysoon

thanks. Anyway I would say mickey64 gave you a perfect answer.

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

I don't know how to move the Ratio under the value Sel.

It is easy making a line chart.