Forum Discussion

nssidhu74's avatar
nssidhu74
Frequent Visitor
6 years ago

Filtering Disconnected Tables based on selection

I am using Direct Query   1. I have a view that uses the following Query Select Distinct(SourceCountry), ( Select MAX(Data_date) from FactInventory FI Where FI.SourceCountry = I.SourceCountry) ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

I think you are looking for category sum and max

 

Please refer

https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/td-p/134279

https://community.powerbi.com/t5/Desktop/SUM-value-by-category/td-p/507457

 

You can also explore quick measure to achieve the same.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970


https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601