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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Resolver I
Resolver I

  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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.