Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
@Anonymous
You can create a calculated table like below:
Table = FILTER(ALL(Table1[Month]),CALCULATE(SUM(Table1[Value]))>800000)
Regards,
@Anonymous
You can create a calculated table like below:
Table = FILTER(ALL(Table1[Month]),CALCULATE(SUM(Table1[Value]))>800000)
Regards,
User | Count |
---|---|
121 | |
69 | |
67 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |