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.
I have a Matrix with rows based on a Division > Cost Center Hierarchy (Engineering and Finance are at the Division Level). I would like to show the SEC Class value on the right but only for the Cost Center Level. That is to say, the values to the right of Engineering and Finance would be blank while the values below for the respective Cost Centers will have the SEC value.
Hi @PaddyHS ,
In this case you would use a function called ISINSCOPE to check. You'll use it against your second level.
VAR _InScope = ISINSCOPE(YOUR_TABLE[Cost Center])
RETURN
IF( _InScope, SUM(YOUR_TABLE[Value]) )
This script throws the visual off. Could it be that you're summing a categorical variable with the SEC Class field? I just want to display whatever value is associated with the respective cost center with the Division level remaining blank.
@PaddyHS
Can you explain "throws the visual off"?
Could you elaborate on your issue?
Would you happen to be able to share some sample data and expected results?
From my test below it does work.
It is the Cogs/OpEx values that I am trying to blank out at the Division level (arrow) and retain the values in the blue circle.
Hi @PaddyHS ,
Here's a sample file for you to test the functionality:
https://1drv.ms/u/s!An8CCFsOzw0uhQwe-YznijpjOjXK?e=8QL3B7
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 |
---|---|
109 | |
99 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |