Forum Discussion
Solved
Using Variables as filters
Hi community I am having a little trouble understanding how to use variables, i have made the following formula: Test = Var Rep = VALUES(Kundetabel[Repræsentant]) Var Kunde = VALUES(Kunde...
ChristianHE , Try like
Test = CALCULATE([Potientiale];TOPN(10,allselected(Kundetabel);[Potientiale],ASC),VALUES(Kundetabel[KUNDENRNAVN]))
ChristianHE , better have to measure with filter sales >1, if it line level. If it after grouping then use values
sumx(Filter(values(Table[Col1]),[sales]>1),[Sales])
amitchandak it works, Thank you very much.
If i wanted to add more filters to my [Kundetabel], for example if i only wanted to see customers with a sales above 1. Would that be possible to add in the formula or should it be added in the "Filters"-pane?
ChristianHE , better have to measure with filter sales >1, if it line level. If it after grouping then use values
sumx(Filter(values(Table[Col1]),[sales]>1),[Sales])