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.
arnomics , Simple create one measure or two measures
calculate(countrows(Table), filter(Product, Product[Color] in {"Red", "Black"} ))
if you create a new table, that table should join to your fact and then use countrows(table) measure
Thanks for your reply amitchandak
The main issue is that I'm using a Published Dataset and adding New Tables, Columns etc. is greyed out. It stops me from doing lot of things that would make my life easier.