Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
omerthy
New Member

Putting up the measure to the visual with correct average grand total

 

Hi Guys, 

 

I am quite new to PBI, I have this problem if you can help that will be great. 

 

in the ss you can see the filters and liquid visual that use for my data. 

in this page I am trying to get the, lets say , total score of a country in a given month. when I choose just  a month it shows me the correct result. However, when I choose april may june , it adds up the score which I dont want it like that. I want to see it as average of the total. there are single KPI(s) and months and scores in the raw data. when I choose the average in the value section it shows me the average of the KPI(s) which is again not someting that I want to see. I ve tried the GROUP BY and SUMMARIZE dax(s) to come up to a solution but ı ve ended up in the same spot where I started. I believe it  is something easy but I dont know what it is . 

thanks for the solutions in advance 

 

 

 

pbi.PNG

1 REPLY 1
sturlaws
Resident Rockstar
Resident Rockstar

Hi @omerthy 

 

here are some tips on how to get your question answer quickly:


How to Get Your Question Answered Quickly

 

Cheers,
Sturla

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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