topic Re: Calculation between a data table and a reference table in DAX Commands and Tips

Calculation between a data table and a reference table

Anonymous — Wed, 23 Jun 2021 11:26:49 GMT

Hello to all,

I am asking for your help concerning a measurement between two tables:
A table that serves as a reference and a table of time-stamped data.

I have created a measure that calculates the difference between a theoretical power and a real power. This measure works:

I would like to be able to count the number of times that this difference is less than or equal to the values that I have in my reference table which is below:

I also present my time-stamped table :

There is no link for the moment between these two tables.

Do you think this is possible?

Thank you in advance for your help,

Have a nice day

Re: Calculation between a data table and a reference table

Anonymous — Wed, 23 Jun 2021 15:08:18 GMT

Yes, I think it's perfectly possible.

Re: Calculation between a data table and a reference table

Anonymous — Wed, 23 Jun 2021 15:50:00 GMT

Hello Anonymous

Great thanks, could you please explain how?

Thanks in advance,

Joel

Re: Calculation between a data table and a reference table

Anonymous — Tue, 29 Jun 2021 09:28:50 GMT

Hello Anonymous

I would like to ask you again about my request, could you please explain the request to create in order to realize my calculation?

Thank you in advance,

Sincerely

Re: Calculation between a data table and a reference table

PaulOlding — Tue, 29 Jun 2021 10:34:41 GMT

Hi. Some example data in table form or a link to the .pbix would have been very useful. Try this measure out. I haven't been able to test it.

Distribution Measure =

VAR _CurrentDistribution = SELECTEDVALUE('dim_distribution'[distribution])
VAR _Result =
COUNTROWS (
FILTER (
VALUES ( 'Table'[dt (1j)] ),
[ecart_modelisation] <= _CurrentDistribution
)
)

RETURN

_Result

Re: Calculation between a data table and a reference table

Anonymous — Tue, 29 Jun 2021 10:46:56 GMT

// It's very simple. // Let's say you've put the // distribution column in // a slicer and you can // select only one option // at a time. Then this measure // would give you the // number of days (=times) where // the measure [ecart_modelisation] // is <= to the selected value/option. // If there is more than one option // visible in the current context, // BLANK is returned. [# Below or Equal] = var DistributionVal = SELECTEDVALUE( dim_distribution[distribution] ) var Result = IF( NOT ISBLANK( DistributionVal ), COUNTROWS( FILTER( DISTINCT( fact_points_mesure[dt(1j)] ), [ecart_modelisation] <= DistributionVal ) ) ) return Result

Re: Calculation between a data table and a reference table

Anonymous — Mon, 05 Jul 2021 14:23:47 GMT

Hello Anonymous and PaulOlding

Thank you for your generous help, have a nice day,

Sincerely