Forum Discussion
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...
Hi arnomics ,
You can use viual filter:
Final 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.
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.
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.