Best way to approach problem

[DavidUK13]

Hi,

I have a dashboard in the making for solar panels.

Would like to connect the Solar Generation with the Export Tables in some way.

I have some measures created.

I also have a table with the Export Prices depending on when the export occurs.

Ultimatly, what I would like to have is a measure that multiples the Export by the Price.

So the 26th of May as an example would be:

Peak Rate

2.7 * 0.337

Day Rate
1.8 *  0.209

Flux Rate

0.0 * 0.082

Then I can create a total. The tables aren't linked as there isn't anything to link them with>>Many thanks in advance.

[v-yanjiang-msft · Accepted solution]

Hi @DavidUK13 ,

According to your description, I create a sample like yours, here's my solution. Create a measure:

Measure =
VAR _peak =
    MAX ( 'Solar Generation'[Export During Peak Rate] )
        * MAXX (
            FILTER ( ALL ( 'Export' ), 'Export'[Tariff Type] = "Peak Rate" ),
            'Export'[Export Price]
        )
VAR _flux =
    MAX ( 'Solar Generation'[Export During Flux Rate] )
        * MAXX (
            FILTER ( ALL ( 'Export' ), 'Export'[Tariff Type] = "Flux Rate" ),
            'Export'[Export Price]
        )
VAR _day =
    MAX ( 'Solar Generation'[Export During Day Rate] )
        * MAXX (
            FILTER ( ALL ( 'Export' ), 'Export'[Tariff Type] = "Day Rate" ),
            'Export'[Export Price]
        )
RETURN
    _peak + _flux + _day

Get the correct result:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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