Forum Discussion
Yonah
Helper II
Helper IICreat Tabel with Value from Meassure
Hi,
I am trying to create a new table with Dax.
In this Table, I want the Value from Measures.
So the table should look like this:
| 5 | Value from Measuere 'Export'[05 Total_Top_5] |
| 10 | Value from Measuere 'Export'[07 Total_Top_10] |
My Dax so far is:
Tabelle =
{
( "5", NAMEOF ( 'Export'[05 Total_Top_5] ) ),
( "10", NAMEOF ( 'Export'[07 Total_Top_10] ) )
}
But if I creat a table with both Coolums the result is this:
The Result I want is
| 5 | 3825 |
| 10 | 5650 |
The Dax for 'Export'[05 Total_Top_5] is:
05 Total_Top_5 =
IF (
ISINSCOPE ( 'Export'[Bezeichnung] )
&& [03 Ranking] > 5,
BLANK (),
SUMX ( VALUES ( 'Export'[Bezeichnung] ), [04 Sum_N1_TOP_5] )
)
The Dax for 'Export'[07 Total_Top_10] is:
07 Total_Top_10 =
IF (
ISINSCOPE ( 'Export'[Bezeichnung] )
&& [03 Ranking] > 10,
BLANK (),
SUMX ( VALUES ( 'Export'[Bezeichnung] ), [06 Sum_N1_TOP_5] )
)
You can finde the pbix-File here
https://1drv.ms/u/s!AoFqgLqZH-C0hMxg78Y7WqkhCHv0xg?e=gc2Vr8
Thanks
Use
Tabelle = CALCULATETABLE( { ( "5", [05 Total_Top_5] ), ( "10", [07 Total_Top_10] ) }, FILTER( KEEPFILTERS( VALUES( 'N1'[N1] ) ), 'N1'[N1] = 0 ), FILTER( KEEPFILTERS( VALUES( 'N2'[Parameter] ) ), 'N2'[Parameter] = 0 ) )
6 Replies
johnt75Super User
Try
Tabelle = { ( "5", [05 Total_Top_5] ), ( "10", [07 Total_Top_10] ) }- johnt75
Use
Tabelle = CALCULATETABLE( { ( "5", [05 Total_Top_5] ), ( "10", [07 Total_Top_10] ) }, FILTER( KEEPFILTERS( VALUES( 'N1'[N1] ) ), 'N1'[N1] = 0 ), FILTER( KEEPFILTERS( VALUES( 'N2'[Parameter] ) ), 'N2'[Parameter] = 0 ) )
YonahThanks
- Yonah
I'm getubg tge Values that I expect.