Forum Discussion

arnomics's avatar
arnomics
Helper I
3 years ago
Solved

Filtering on a CALCULATETABLE function

Hi all,   I'm trying my luck again as my previous post might've been complicated. I'll try to simplify this post.  I have created the below Variable - to produce & isolate a list of Customers that...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi arnomics ,

 

Based on your description, I have created a simple sample:

Please try:

Table = 
var _a = FILTER('Customer',[City]="Hobart")
return SUMMARIZE(_a,[City],Customer[Customer Code],"Red or Black Count",CALCULATE(COUNT('Product'[Product Code]),FILTER('Product',[Color] in {"Red","Black"})))

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • arnomics's avatar
    arnomics
    Helper I
    3 years ago

    Thanks for your reply v-jianboli-msft 

    Since I am using a Published dataset I cannot create a Table in the Data Model. But instead I was hoping to create a Measure that would allow me to drag & drop Columns from the table different tables with the Measure that I created.