topic Re: Dynamic sum the measures based on the a slicer with these measure name in DAX Commands and Tips
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1886192#M40613
<P>Hi <SPAN>amitchandak,</SPAN></P><P> </P><P><SPAN>For example, i have a table below which all the columns are a measure using rankx for different factors:</SPAN></P><P>Company Factor 1 Factor 2 Factor 3 Factor 4</P><P>Company1 1 2 3 2</P><P>Company2 2 1 2 3</P><P>Company3 3 3 1 1</P><P> </P><P>what i want to achieve is to have a slicer for different factors:</P><P><STRONG>Factor 1 (Selected)</STRONG></P><P><STRONG>Factor 2 (Selected)</STRONG></P><P>Factor 3</P><P>Factor 4</P><P> </P><P>And the new measure X will be the sum of all the ranking scores i have selected:</P><P>Company Factor 1 Factor 2 Factor 3 Factor 4 X</P><P>Company1 1 2 3 2 3</P><P>Company2 2 1 2 3 3</P><P>Company3 3 3 1 1 6</P><P> </P><P>if i choose <STRONG>Factor 1 + Factor 2 + Factor 3</STRONG>, the X will show the sum of these 3 factor rankings.</P><P> </P><P>Best,</P><P>Zhengyang</P>Mon, 07 Jun 2021 17:48:42 GMTHakun_Matata2021-06-07T17:48:42ZDynamic sum the measures based on the a slicer with these measure name
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1885730#M40602
<P>Hi,</P><P> </P><P>I have a table which is basically contains rankings for different facts, all these rankings are measures which use the rankx formula.</P><P> </P><P>What i want to achieve is to have a slicer with these factor names and by selecting different factor names in this slicer, i would like to have a new measure which sums the ranking measures for the selected factor (the selected measure can be either single or multiple).</P><P> </P><P>Any idea on if this is possible to achieve in power BI? thanks in advance!</P><P> </P><P>Best,</P><P>Zhengyang</P>Mon, 07 Jun 2021 14:21:52 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1885730#M40602Hakun_Matata2021-06-07T14:21:52ZRe: Dynamic sum the measures based on the a slicer with these measure name
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1886123#M40611
<P><LI-USER uid="238590"></LI-USER> ,The information you have provided is not making the problem clear to me. Can you please explain with an example. <BR />I think you need something like</P>
<P><A href="https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415" target="_blank">https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415</A><BR /><STRONG>Appreciate your Kudos.</STRONG><BR /><BR /></P>Mon, 07 Jun 2021 16:52:33 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1886123#M40611amitchandak2021-06-07T16:52:33ZRe: Dynamic sum the measures based on the a slicer with these measure name
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1886192#M40613
<P>Hi <SPAN>amitchandak,</SPAN></P><P> </P><P><SPAN>For example, i have a table below which all the columns are a measure using rankx for different factors:</SPAN></P><P>Company Factor 1 Factor 2 Factor 3 Factor 4</P><P>Company1 1 2 3 2</P><P>Company2 2 1 2 3</P><P>Company3 3 3 1 1</P><P> </P><P>what i want to achieve is to have a slicer for different factors:</P><P><STRONG>Factor 1 (Selected)</STRONG></P><P><STRONG>Factor 2 (Selected)</STRONG></P><P>Factor 3</P><P>Factor 4</P><P> </P><P>And the new measure X will be the sum of all the ranking scores i have selected:</P><P>Company Factor 1 Factor 2 Factor 3 Factor 4 X</P><P>Company1 1 2 3 2 3</P><P>Company2 2 1 2 3 3</P><P>Company3 3 3 1 1 6</P><P> </P><P>if i choose <STRONG>Factor 1 + Factor 2 + Factor 3</STRONG>, the X will show the sum of these 3 factor rankings.</P><P> </P><P>Best,</P><P>Zhengyang</P>Mon, 07 Jun 2021 17:48:42 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1886192#M40613Hakun_Matata2021-06-07T17:48:42ZRe: Dynamic sum the measures based on the a slicer with these measure name
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1901652#M41011
<P>okay, i have fixed myself. thanks anyway.</P>Tue, 15 Jun 2021 14:37:16 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Dynamic-sum-the-measures-based-on-the-a-slicer-with-these/m-p/1901652#M41011Hakun_Matata2021-06-15T14:37:16Z