topic Create a table from 0 to a 'dinamic value' in DAX Commands and Tips

Create a table from 0 to a 'dinamic value'

BTI_Afuentes — Wed, 15 Apr 2020 00:21:26 GMT

Hi,

I have a list of methodologies and indicators for each methodology. Then I created a summarized table where I identified total MAX possible points for each Metodology.

Now I need to create a table (or maybe a column) with values from 0 to MAX points for each methodology.

New table (from 0 to 'total max points) will be used for a line chart)

How can that be achieved?

Thanks,

Angel

Re: Create a table from 0 to a 'dinamic value'

Greg_Deckler — Wed, 15 Apr 2020 02:17:07 GMT

So, sample data would help but perhaps something along the lines of:

Table Methodology 1 = GENERATESERIES(0,MAXX(FILTER('Table'),[Methodology] = "Methodology 1"),[Points]),1)

There is a good bet that all of the assumptions I made are incorrect.

Re: Create a table from 0 to a 'dinamic value'

BTI_Afuentes — Thu, 16 Apr 2020 05:21:30 GMT

Thank you very much for your help Greg.

I'm attaching an example of the tables. I tried with your suggestion but is this for generate a table for each methodology?

Projects table:

Project ID	Methodology ID
Project 1	Methodology 1
Project 2	Methodology 2

Methodologies table (summarized table)

Methodology ID	Max points
Methodology 1	100
Methodology 2	150
Methodology 3	90

Indicators table:

Indicator ID	Points	Methodology ID
Indicator 1	20	Methodology 1
Indicator 2	30	Methodology 1
Indicator 3	50	Methodology 1
Indicator 4	10	Methodology 2
Indicator 5	20	Methodology 2
Indicator 6	50	Methodology 2
Indicator 7	70	Methodology 2
Indicator 8	20	Methodology 3
Indicator 9	20	Methodology 3
Indicator 10	20	Methodology 3
Indicator 11	30	Methodology 3

New table:

(column 2 is a calculated by a formula: =1/(1+EXP(-(('Methodology max ponts'/2)-Column1')*LN(2)/4))

Column1	Column2
0	99.98%
1	99.98%
2	99.98%
3	99.97%
4	99.97%
5	99.96%
…
100	0.02%

I tried to attach an excel file but didn't find the option.

Thanks again,

Re: Create a table from 0 to a 'dinamic value'

BTI_Afuentes — Fri, 17 Apr 2020 06:44:57 GMT

Hi,

Also, this is a link for a pbix file. Hope it helps

https://1drv.ms/u/s!AnDB-UKsg60w40wePfnmrXhzWiAE?e=aAFiZL

Thanks,

Re: Create a table from 0 to a 'dinamic value'

BTI_Afuentes — Mon, 20 Apr 2020 21:55:35 GMT

Hi,

Is there any suggestion for creating the chart required?

Thanks,

Angel