Reply
avatar user
Anonymous
Not applicable

Measure from PBI dataset blank under "Aggregate"

Hello everyone. 

 

I am very new to the Report Building tool, but I cannot find a solution to this very simple scenario (or maybe I am not understanding the other entries in the forum).


I want to replicate this simple matrix:

Albsangon1_0-1701712263718.png


Where, as can be seen, the third column is the result of the second divided by the first.

In Report Builder, I get something like this when I build the query:

Albsangon1_1-1701712365626.png



Great! The numbers are the same. Good. Now let's add it to a matrix:

Albsangon1_2-1701712414660.png

Note that I select "Aggregate" because I don't want the averages to be summed. This I learnt from Paginated Reports in a day tutorials, it can be seen in https://www.youtube.com/watch?v=JhEa_TugXeE&list=PL1N57mwBHtN1icIhpjQOaRL8r9G-wytpT&index=15&ab_chan... at 16:08.

After finishing the matrix, I get an empty result:

Albsangon1_3-1701712514490.png



For some reason I cannot undestand, if I enter the query editor and leave it, the query seems to update itself (why does this happen??) and now I get the following:

Albsangon1_4-1701712590023.png


Again, I am completely new to the topic, and I'm sure I must be missing something very basic. Could someone please point me in the right direction?

Thank you in advance for your time,

Alberto.

 



0 REPLIES 0
avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)