Forum Discussion

Yonah's avatar
Yonah
Icon for Helper II rankHelper II
3 years ago
Solved

Creat 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 ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    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 )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Tabelle =
{
( "5", [05 Total_Top_5]  ),
( "10", [07 Total_Top_10]  )
}
  • Yonah's avatar
    Yonah
    Icon for Helper II rankHelper II
    3 years ago

    Hi,
    if I try this DAX, I get empty colums.

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      3 years ago

      what do you get if you put the measures on card visuals with no filters applied ?