DAX Queries

[Anonymous]

In my Power BI Report I'm having,

Month        Value

August        1,24,000

September   2,46,789

October       8,49,000

November   2,04,985

December    90,485

Now, I want to display the value of all the months to above 8,00,000 through DAX Queries. How can I do that.

[v-sihou-msft · Accepted solution]

@Anonymous

You can create a calculated table like below: 

Table = FILTER(ALL(Table1[Month]),CALCULATE(SUM(Table1[Value]))>800000)

Regards,