Forum Discussion
Distinct count based on the sum and month
Anonymous , Try like
countx(filter(summarize(Table, Table[Vehicle Number], "_1",
CALCULATE(sum(Table[Km Driven]),DATESINPERIOD(Master_Data[Month ],MAX(Master_Data[Month ]),-3,MONTH))),[_1]<10),[Vehicle Number])I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-ye5L
Super UserAnonymous , Try like
countx(filter(summarize(Table, Table[Vehicle Number], "_1",
CALCULATE(sum(Table[Km Driven]),DATESINPERIOD(Master_Data[Month ],MAX(Master_Data[Month ]),-3,MONTH))),[_1]<10),[Vehicle Number])
I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-ye5L
Hi,
Is it possible if I can aslo calculate the sum of km driven for those vehicles as well? I want to show the sum of km driven in last 3 month just next to the Overall Km driven of all vehicle in another column in table i.e Sum of km
I am trying the below DAX query but unable to fetch the results.
SUMx(filter(summarize(Master_Data, Master_Data[Item], "_1",CALCULATE(sum(Master_Data[Utilisation KM]),DATESINPERIOD(Master_Data[Month ],MAX(Master_Data[Month ]),-6,MONTH))),"_1"<10)Kindly help