CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

03 December, 2023

Power BI Issue: Calculated Items Misbehaving When Filtering

 Programing Coderfunda     December 03, 2023     No comments   

I'm encountering a perplexing issue in my Power BI report that involves calculated items. Any insight or suggestion is much appreciated.


Here's a breakdown:


Data Model:



* FactData

* DimProductHierarchy

* DimVersionName1 (disconnected table)

* DimVersionName2 (disconnected table)






Measures:



* [Volume] = SUM(FactData[Volume]






Table Chart1:
Category column - DimProductHierarchy[Level 1]
Value - "Version 1", which is a calculated item I created in Tabular Editor


Table Chart2:
Category column - DimProductHierarchy[Level 1]
Value - "Version 2", which is a calculated item I created in Tabular Editor


Slicer1
Used column - DimVersionName1[Version Name]
Only applied to - Table Chart 1


Slicer2
Used column - DimVersionName2[Version Name]
Only applied to - Table Chart 2


Calculated Items 1 (Version 1):
VAR SelectedVersion1 = SELECTEDVALUE(DimVersionName1[Version Name]) VAR MyFilter = FILTER(ALL(FactData[Version Name]), FactData[Version Name] = SelectedVersion1) VAR Result = CALCULATE(SELECTEDMEASURE(), MyFilter) RETURN Result


Calculated Items 2 (Version 1):
VAR SelectedVersion2 = SELECTEDVALUE(DimVersionName2[Version Name]) VAR MyFilter = FILTER(ALL(FactData[Version Name]), FactData[Version Name] = SelectedVersion2) VAR Result = CALCULATE(SELECTEDMEASURE(), MyFilter) RETURN Result


Other Details:



* FactData and DimProductHierarchy are connected with the Many-to-One relationship.






The Problem:
When I click on a category in Table Chart 1, Table Chart 2 correctly filters to display only that selected category. However, the measure value in Table Chart 2 unexpectedly changes to match the value in Table Chart 1, rather than retaining its original value.


Question:
Can someone help me understand why the measure in Table Chart 2 is getting affected by the interaction with Table Chart 1, and how I can ensure that each visual maintains its own measure value?
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • How does this Facade works Question : The bounty expires in 6 hours. Answers to this question are eligible for a +50 reputation bounty. … Read More
  • Bandwagon is a Social Proof Package for Laravel Laravel Bandwagon is a package to help promote social proof and legitimacy within your application. You can let users of your application k… Read More
  • Socialite Implementation for Laravel Jetstream Socialstream is a package by Joel Butcher that provides a simple Socialite implementation for Laravel Jetstream.Installing this p… Read More
  • Adding hreflang tags automatically in WordPress subdirectory multisite We have a WordPress MU subdirectory network setup:www.example.com - main website, USA, globalwww.example.com/uk/ - to display for UK v… Read More
  • httpful POST request: get raw HTTP message  Answerstry { $url = 'https://httpbin.org/post1'; // hasErrors // $url = 'https://httpbin.org1/post'; // ConnectionErrorException … Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Features CodeIgniter
    Features CodeIgniter There is a great demand for the CodeIgniter framework in PHP developers because of its features and multiple advan...
  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • Laravel Breeze with PrimeVue v4
    This is an follow up to my previous post about a "starter kit" I created with Laravel and PrimeVue components. The project has b...
  • Fast Excel Package for Laravel
      Fast Excel is a Laravel package for importing and exporting spreadsheets. It provides an elegant wrapper around Spout —a PHP package to ...
  • Send message via CANBus
    After some years developing for mobile devices, I've started developing for embedded devices, and I'm finding a new problem now. Th...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (68)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

  • Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh - 9/21/2024
  • pyspark XPath Query Returns Lists Omitting Missing Values Instead of Including None - 9/20/2024
  • SQL REPL from within Python/Sqlalchemy/Psychopg2 - 9/20/2024
  • MySql Explain with Tobias Petry - 9/20/2024
  • How to combine information from different devices into one common abstract virtual disk? [closed] - 9/20/2024

Laravel News

  • Larallow is a Permissions Package With Support for Scopes - 6/17/2025
  • Laravel Nightwatch - Deep monitoring & insights, no matter where you deploy. - 6/17/2025
  • Filament v4 Beta - Feature Overview - 6/16/2025
  • AnyCable Laravel Broadcaster - 6/16/2025
  • Parse Localized Numbers with Laravel's Number Class - 6/16/2025

Copyright © 2025 CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda