Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Queries

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 ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    Anonymous

     

    You can create a calculated table like below: 

     

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

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Anonymous

 

You can create a calculated table like below: 

 

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

 

Regards,