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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Analitika
Post Prodigy
Post Prodigy

Wrong calculating in visual Power bI

Hello,

 

I would like to ask how fix calculation in visual because if I select on one account name other visual shows total sum not that which was selected. How to solve this issue? The example below:

Analitika_0-1702455563340.png

In this in Kanalas visual I should see 362.517 but I see 4283250 instead. That's wrong filtering, how to solve my issue?

 

 

7 REPLIES 7
Digger
Post Patron
Post Patron

because sas_kod does not related to your visuals

Bibiano_Geraldo
Super User
Super User

  1. Make sure that interations between Kansas Visual and Matrix are activated to filter values.
  2. Make sure that you are using the same mesure for Matrix and Kansas Visual.
  3. Make sure that you are not clearing filters using DAX Functions like ALL in your measure.

if this steps dont help you, please provide your measure DAX code.

Not helped.

BP measure: 

Bendrasis pelnas = [_1_3_1_BP Pardavimai_bruto]-[_1_3_0_BP Pardavimų grąžinimai]-[1_Nuolaidos]-[Savikaina]
 
Grazinimai in table corresponds to [_1_3_0_BP Pardavimų grąžinimai].
calculated from same table.
 All time getting that values:
Analitika_0-1702467594394.png

Pardavimai (net) also calculated same value. 

_1_1_0_BP Pardavimai DK+-50

Can you share you sample pbix file? 

No, because contains sensitive data.

Idrissshatila
Super User
Super User

Hello @Analitika ,

 

there should be a relationship between the dimension you're clicking on and the table that has the value that appears to be wrong.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




I am calculating measures from same table just different types - categories. In this case it has same code and account name. 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors