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 Team,
Below is My input file:
Date | Amount |
06-06-2020 | 500 |
05-06-2020 | 700 |
Required OutPut
Currently i am using matrix tile , I have created one measure for variance (Between two dates) when i drag the same measure in to matrix tile it will be repeating for the two dates like below snap.
But i want to show variance only one time like below snap
Can you please help me out on this?
Thanks In Advance
Solved! Go to Solution.
Hi @Anonymous ,
If you don't need the total column, you could use ISINSCOPE() to replace it as variance.
Here is the measure for your reference.
Measure =
IF ( ISINSCOPE ( 'Table'[Date] ), SELECTEDVALUE ( 'Table'[Amount] ), [Your variance])
@Anonymous ,
This kind of display you want is not supported. I posted an idea for that
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table
Thanks for the quick reply amit.
I understood that by default matrix is not supported.
Can we get calculated table (Using Calculated Table,Union ..)like below ?
Once we achieve this below kind of table then only will achieve that requirement
Date | Amount |
06-06-2020 | 500 |
05-06-2020 | 700 |
Variance | 500-700/700 |
Thanks In Advance
Hi @Anonymous ,
If you don't need the total column, you could use ISINSCOPE() to replace it as variance.
Here is the measure for your reference.
Measure =
IF ( ISINSCOPE ( 'Table'[Date] ), SELECTEDVALUE ( 'Table'[Amount] ), [Your variance])
Hi @v-eachen-msft ,
Your measure is working as expected. Thanks for that. and also
I just wanted to know about to add calculate row to an existing column based on some custom calculation like in output
Input
id value
1 10
2 20
Output:
id value
1 10
2 20
Sub 10-20
Hi @Anonymous ,
Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.
Hi @Anonymous ,
You coudld create a new calculated table.
Table 2 =
UNION (
'Table',
DISTINCT (
SELECTCOLUMNS (
'Table',
"id", "Variance",
"value", MIN ( 'Table'[value] ) - MAX ( 'Table'[value] )
)
)
)
Here is the result.
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 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |