I'm new in the PBI and need some help from the start.
For example I have this table:
I want to show everyone how much of bread in the month each one ate and the total quantity in the month.
I create these measures:
But the Count Food needed to show 6 (Total of 01/06/2020).
I tried to use another measures with all, allselected but didn't work.. Can someone help me please?
Solved! Go to Solution.
Hi @Felipeamartinz ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Hi @Felipeamartinz ,
Create a measures
Count Food = CALCULATE(COUNT('Table'[Food]),ALLEXCEPT('Table','Table'[Date]))
CountName = COUNT('Table'[Name])
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hello @harshnathani ,
Thanks for the answer.
It worked, but after input more data It doesn't work when I filter the data.
1. create a calendar table like
CalendarTable = CALENDAR(DATE(2020,1,1),DATE(2020,12,31))
2. create relationship between calendar table and Planilha1 table by date field
3. Add CalendarTable[Date] to date slicer visual
4. create a measure in Planilha1 table
Count Food = VAR MaxDate = CALCULATE(MAX(CalendarTable[Date])) VAR MinDate = CALCULATE(MIN(CalendarTable[Date])) RETURN CALCULATE(COUNTROWS(Planilha1), FILTER(ALL(Planilha1), Planilha1[Date] >= MinDate && Planilha1[Date] <= MaxDate))
Hello @az38 ,
Thanks for joining us and helping me with the solution.
I did what you said, but didn't show the number of total of bread when I filter, follow the image:
Check out new user group experience and if you are a leader please create your group
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.