Forum Discussion
Solved
Power Query - how to exclude members where measure is blank?
Hi Community, I hope you are doing very good. I have a data model in Excel trough Power Query where I have the Sales table and the Budget table. Also, I've created a master table for products and...
For such model we could use two measures:
Order quantity:=SUM ( Orders[Orders] ) Budget quantity:=CALCULATE ( SUM ( Budget[Budget] ), TREATAS ( VALUES ( Orders[Product] ), Budget[Product] ) )Result is
Adding the relationships:
For such model we could use two measures:
Order quantity:=SUM ( Orders[Orders] )
Budget quantity:=CALCULATE (
SUM ( Budget[Budget] ),
TREATAS (
VALUES ( Orders[Product] ),
Budget[Product]
)
)
Result is
SergeiBaklan Excellent! it works fine! thank you very much!! You helped me a lot!! Regards.Ale
alejopiero , you are welcome