Forum Discussion
Counting rows
Hi Zeesh1979 ,
I made a simple file, please check the model:Total Sales = VAR _month = SELECTEDVALUE('Calendar'[Month]) VAR _total = CALCULATE(SUM('SalesTable'[Sales]),FILTER('SalesTable',_month>MONTH('SalesTable'[Date]))) + 0 RETURN _totalBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
how? can u plz elaborate
Zeesh1979 Hard to be specific with the amount of information you provided. It should be something along the lines of:
Better RT = VAR __Date = MAX('Table'[Date]) VAR __Table = FILTER(ALLSELECTED('Table'),[Date] <= __Date) RETURN SUMX(__Table,[Value])Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Item Sales Month Cars 100 Jan Bikes 150 Feb Cars 50 Jan Bikes 120 March expected output if March filter selected
Total Sales 300 expected output if Feb filter selected
Total Sales 150 i hope this helps more...(im new to community and learning how to improve asking question)
