Using USERELATIONSHIP to Activate Inactive Relationships

preview_player
Показать описание
By default, Power BI will only use the data column relating to the active relationships when using columns from multiple tables in your visuals. In this video, Angelica will show you how to use the DAX function, USERELATIONSHIP to activate inactive relationships to make your data analysis more meaningful.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
#PragmaticWorks
  1. Pragmatic Works
  2. pragmatic works
  3. demo
  4. learn
  5. Angelica Domenech
  6. power bi
Рекомендации по теме
Using USERELATIONSHIP to 0:12:04

Using USERELATIONSHIP to Activate Inactive Relationships

Using USERELATIONSHIP in 0:03:24

Using USERELATIONSHIP in DAX

DAX Fridays #212: 0:06:36

DAX Fridays #212: Using inactive relationships in slicers | USERELATIONSHIP

How to use 0:08:39

How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021

How to solve 0:08:45

How to solve Inactive Relationship Problem with Role Playing Dimensions in Power BI

6 - Intro 0:03:02

6 - Intro to DAX: Use the inactive relationship with CALCULATE and USERELATIONSHIP

Drillthrough for Inactive 0:14:29

Drillthrough for Inactive Relationship or Userelationship Measure - Power BI Desktop Tips (43/100)

Power BI - 0:09:50

Power BI - How to handle Multiple Dates | Active Inactive Relationships | UseRelationship

USERELATIONSHIP Function in 0:05:53

USERELATIONSHIP Function in DAX

USERELATIONSHIP Function in 0:01:00

USERELATIONSHIP Function in DAX

Power BI inactive 0:05:12

Power BI inactive relationships with CALCULATE & USERELATIONSHIP

How to Use 0:06:31

How to Use Inactive Relationship In Power BI using DAX- USERELATIONSHIP - Interview Question PowerbI

USERELATIONSHIP - DAX 0:02:10

USERELATIONSHIP - DAX Guide

Multiple Relationships In 0:08:17

Multiple Relationships In Power BI using USERELATIONSHIP() - Handling Inactive Relationship

How to use 0:06:34

How to use Inactive relationship in measures? USERELATIONSHIP is the function you need!

Relationship DAX Functions 0:14:40

Relationship DAX Functions in Power BI | USERLATIONSHIP And CROSSFILTER DAX Function

Active vs Inactive 0:00:10

Active vs Inactive Relationship in Power BI | PowerBI Desktop | #powerbi #daxfunctions

USERELATIONSHIP function in 0:05:20

USERELATIONSHIP function in power bi DAX | activate the inactive relationship | power query

USERELATIONSHIP in DAX 0:12:05

USERELATIONSHIP in DAX | Power BI | Complete Hands-On | Most Asked Interview Question | DAX

What is Roleplaying 0:08:55

What is Roleplaying Dimension | INACTIVE Relationship | USERELATIONSHIP Function IN DAX (50)

Understanding USERELATIONSHIP Function 0:05:19

Understanding USERELATIONSHIP Function in DAX

Power BI Using 0:04:48

Power BI Using Inactive Relationships | Userelationship in PBI | Two Join Conditions between tables

Changing inactive relationship 0:07:23

Changing inactive relationship to active relationship using DAX in Power BI

Userelationship dax function 0:02:57

Userelationship dax function to handle inactive relationship - 46 (Power BI Training)

Комментарии
Автор

Straight forward! Thank you for putting this video together!!!!

osPA
Автор

Thank you for this resource. 😃 Question RE 10'39" mark of video: How is it that the Quantity by Ship Date (729) is greater than the Sum of OrderQuantity? I've never worked in a context that tracked these sorts of values; I wonder if the 729 figure represents some items shipped over the course of 2012 Quarter 1 that were 'sold' in 2011? Thanks for sharing if my question makes sense LOL.

geralddahl
Автор

Hi I need help using inactive relationships. I have a calendar table with two values() tables of year from that calendar. I need to filter the years where there are spaces from the slicers using both those tables. The onde that is active works ok. The inactive one never gets filtered. Using normal sales from the facts or using sales with use related table. How can I get the value that don't return sales form the slicer using the year on the inactive relationship

welcometomathy