Forum Discussion

rautaniket0077's avatar
rautaniket0077
Icon for Resolver I rankResolver I
1 year ago

Aggregation based on group by/ summarization and filter.

 Hi, i have attached the sample data now there are couple of things that i want to achieve using power bi-   1) first thing is i need to filter the table  based on the month-year selected from the ...
DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
1 year ago

Hi rautaniket0077 ,

 

Here’s the final version that works and dynamically counts the rows for the last 12 months:

External_Count_Only =
CALCULATE(
    COUNTROWS(
        FILTER(
            'Table',
            'Table'[External] > 0 &&
            'Table'[Internal] = 0 &&
            'Table'[Warranty] = 0 &&
            'Table'[Insurance] = 0
        )
    ),
    'Calendar'[Date] >= MAX('Calendar'[Date]) - 365
)

 

 

I have attached an example pbix file for your reference.

 

Best regards,

 

  • rautaniket0077's avatar
    rautaniket0077
    Icon for Resolver I rankResolver I
    1 year ago

    Hi DataNinja777 ,
    Thank you for the reply we want to exclude current month-year and -365 from your measure include it, for more details please check my post and my reply to tharunkumarRTK .

    Thank you.