Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am a newby and tried the VAR Function. Has anyone an idea, why it doesnt work?
Thanks a lot
Martin
Solved! Go to Solution.
Hi @Rupilas,
It looks like you're commenting everything out. When you use an comment operator everything after the operator becomes a comment. Try using /* to open and */ to close the comment instead.
Sales Summary =
VAR SalesTableWithCustKey = Filter(/* Filter Table */ 'Fact Sale', /* Filter Condition */ 'Fact Sale'[Customer Key]>0)
VAR SalesTableGrouped = SUMMARIZE(/* Table to Summarize */ 'SalesTableWithCustKey','Fact Sale'[Customer Key],/* Aggregated Colum Name Expression */ "Total Spend", SUM('Fact Sale'[Total Including Tax])
VAR SummaryTableFiltered = TOPN(/* Numbers of rows to return */ 10, /* Table to filter */ SalesTableGrouped, /* Order by Expression */ [Total Spend])
RETURN SummaryTableFiltered
Proud to be a Super User!
Hi @Rupilas,
It looks like you're commenting everything out. When you use an comment operator everything after the operator becomes a comment. Try using /* to open and */ to close the comment instead.
Sales Summary =
VAR SalesTableWithCustKey = Filter(/* Filter Table */ 'Fact Sale', /* Filter Condition */ 'Fact Sale'[Customer Key]>0)
VAR SalesTableGrouped = SUMMARIZE(/* Table to Summarize */ 'SalesTableWithCustKey','Fact Sale'[Customer Key],/* Aggregated Colum Name Expression */ "Total Spend", SUM('Fact Sale'[Total Including Tax])
VAR SummaryTableFiltered = TOPN(/* Numbers of rows to return */ 10, /* Table to filter */ SalesTableGrouped, /* Order by Expression */ [Total Spend])
RETURN SummaryTableFiltered
Proud to be a Super User!
Hi Watsky,
many thanks for the quick answer
Somehow it still doesnt work.
Now I tried to do it without comments when I start to write VAR3 then it is red underlined and doesnt work.
Could you have another look?
Now I solved it It was one bracket too much, Many thanks to you!!!!
Happy to Help! Glad you're good to go now.
Proud to be a Super User!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |