Forum Discussion

MH_Ger's avatar
MH_Ger
Frequent Visitor
5 years ago

How to reference a column in a virtual table created by Summarize()

Hi,

 

I want to reference a column ("Bestellungen") that I create using Summarize(). However, that does not work (see error in the second picture). How can I accomplish this?

 

2 Replies

  • DimaMD's avatar
    DimaMD
    Icon for Solution Sage rankSolution Sage

    hi
     You need to use mesure [Vertrage] > 1

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    MH_Ger Once you use virtual tables, CALCULATE becomes useless. You would use COUNTROWS(FILTER(varTable,[Bestellungen]>1))