Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have dax question.
I would like to filter my Matrix table based on the value of a sublevel.
Current Set up:
Level 1 : ParentAccount
Level 2: Account
Level 3: Contract
I created a Delta measure that calculates the difference between 2 selected dates.
"P1" & "P2".
Next I would like the filter my rows based on the value of Account! If Delta of Account = 0 then it shouldn't show.
This is where I'm stuck. Anyone an Idea how I can filter this Matrix?
as an example, this line should not show.
Robin
Solved! Go to Solution.
Hi, @Anonymous
According to your description, I can understand what you want to achieve, you want to make the rows that Delate is 0 and is in the scope of [ParentAccount] to disappear in the Matrix, right? You can try my steps:
This is my test data based on your Matrix:
I created these two measures:
Delta = SUMX('Table',[P2]-[P1])
Flag =
IF(
ISINSCOPE('Table'[Parent Account]),
IF(
[Delta]=0,0,1),1 )
Then I created a Matrix and place it like this:
As you can see, the row in which Delta is 0 can still appear in the Matrix.
Then I apply a filter to this Matrix, like this:
Then the row disappeared, and you can get what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
According to your description, I can understand what you want to achieve, you want to make the rows that Delate is 0 and is in the scope of [ParentAccount] to disappear in the Matrix, right? You can try my steps:
This is my test data based on your Matrix:
I created these two measures:
Delta = SUMX('Table',[P2]-[P1])
Flag =
IF(
ISINSCOPE('Table'[Parent Account]),
IF(
[Delta]=0,0,1),1 )
Then I created a Matrix and place it like this:
As you can see, the row in which Delta is 0 can still appear in the Matrix.
Then I apply a filter to this Matrix, like this:
Then the row disappeared, and you can get what you want.
You can download my test pbix file here
If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , isinscope and checking value should help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
if( isinscope(Table[account]) && Max(Table[account]) = "Abc", [Measure1], [measure2])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |