Forum Discussion
AndreiK15
Helper II
Helper IICreate measure with dynamic filters
I have a table with stores - each store has a format type (ex. STANDARD, MEDIUM, MINI). I have total sales for all stores. I want to create a table with all my stores and their formats and divide eac...
SOLVED:
Here's the solution for who's interested:
Category Sales National =CALCULATE(SUM(Sales[Sales Net Amt]),ALLEXCEPT(Sites,Sites[Site Type 02])) - this will give me a total for each site type for each categoryFormat Sales = CALCULATE(SUM(Sales[Sales Net Amt]),ALLEXCEPT(Sites,Sites[Site Type 02]),REMOVEFILTERS('Merchandise Structure')) - this will give me a total for each site type.Sorry, I'm new to Power BI. I had this made on Excel, but the file became larger and I had to find a solution with Power BI.Thank you parry2k !
AndreiK15Helper II
Helper IISOLVED:
Here's the solution for who's interested:
Category Sales National =
CALCULATE(SUM(Sales[Sales Net Amt]),ALLEXCEPT(Sites,Sites[Site Type 02])) - this will give me a total for each site type for each category
Format Sales = CALCULATE(SUM(Sales[Sales Net Amt]),ALLEXCEPT(Sites,Sites[Site Type 02]),REMOVEFILTERS('Merchandise Structure')) - this will give me a total for each site type.
Sorry, I'm new to Power BI. I had this made on Excel, but the file became larger and I had to find a solution with Power BI.
Thank you parry2k !