Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

CalculateTable help

I need to return a calculate table with the datarows highlighted below. Basically All rows from the table where Marker =1  The column Marker is a DAX measure .  Report Date   EDW CustomerID...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your Reply Fowmy .

 

But the CALCULATETBALE expression the way you mentioned above gives me an error 

Not sure why ? and how to get rid of this error?
Is this becasue IndexRow Measure is a DAX measure with zeros/ones value? 
Please help me understand this error as well the best possible approach to achieve the desired output
Thanks 

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
5 years ago

HI Anonymous ,

 

You have mentioned you need to calculatetable where marker = 1 right? So your code would be like below:-

member_channel_new = 
CALCULATETABLE (
    'Member channel Utilization',
    'Member channel Utilization'[marker] = 1
)

Thanks,

Samarth