Forum Discussion

Veigar's avatar
Veigar
Frequent Visitor
5 years ago
Solved

Table as a variable doesn't work

Hi everyone, I have created a table variable: Measure_ = Var _table = SUMMARIZE( CALCULATETABLE( STOCK, FILTER(STOCK, RELATED(_Outliers[Outlier cost]) <> "Outlier"), ...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Veigar ,

     

    you can filter a calculated table. I don't see why this should not be possible.

     

    The measures you posted in the initial post cannot work. You put variables (VAR) but there is no RETURN. That just doesn't work. Check out the syntax:

    RETURN – DAX Guide

     

    But as far as I understand that measure is not working at the moment, right?

    I realized you want to do some ABC analysis. Check the article on dax patterns, maybe that will help you:

    ABC classification – DAX Patterns

     

    Best regards

    Denis

Veigar's avatar
Veigar
Frequent Visitor
5 years ago

Hi selimovd, thanks for the answer.
I had a static table and so i cannot use any filter. 
So i tried to build this measure. The aim of this measure is to calculate the quantity of the items in "A CLASS". (ABC Analysis). 
I wanted to calculate the numbers of A and i tried to add these columns: Cumulated stock, Cumulated percentage, ABC value (Which will be a IF function).

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Veigar ,

 

what is a static table?

And why can't you post the measure?

 

Best regards

Denis