Forum Discussion

Luuky's avatar
Luuky
Helper I
4 years ago

How to create unique values for sum function?

Dear Reader,   Currently i am working on a dashboard with weather data. I am pretty new to PowerBI and working on improving my skills.  The problem i am facing is: FullSunHour needs to be seen as...
Need Help
Luuky's avatar
Luuky
Helper I
4 years ago

Hi Amitchandak,

 

When I implement it, this is result (named the measure SunHour):

Does not seem to be working and the values are wrong now aswell.

 

 

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Luuky ,

 

The formula amitchandak  provided is correct, with just a slight error. Please try the following formula.

fullSunHour1=
SUMX (
    SUMMARIZE (
        'KNMI DATA',
        'ALL location'[WeatherStationKey],
        'Date'[Year],
        "full", [Full sun hour]
    ),
    [full]
)

 

Best Regards

Community Support Team _ chenwu zhu

 

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

  • Luuky's avatar
    Luuky
    Helper I
    4 years ago

    Hello v-chenwuz-msft amitchandak ,

    Thanks for your responses, I managed to complete the dashboard using measures. Some of the measures I had to combine with Sumx(), Calculate() and DistinctCount(). 

    To fix the FullSunHour problem I did the following:

    Measure: FullSun = SUMX('KNMI DATA','KNMI DATA'[    Q]*(1/360))

    Followed by:

    Measure: NewFullSun = SUMX('All locations', [FullSun])

    That somehow made it sum the correct way.

    Thanks for your responses!

     

    Greetings,

     

    Luuk