Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two tables.
I create a measure Max_Week according to one table.
and created a Chart according to the other table.
I want to restrict the x-axis max value according to the measure Max_week. Is it possible?
Thank you!
Is there any suggestion? Thank you!
Here is my demo pbix file. <https://1drv.ms/u/s!AsM9bO8zGUN6qzfNZxmmRlNzWq-O?e=DhTMyQ>
You Graph is already responding to the slicer. Do you want to stop that?
The x-axis max value is always 1917.
I want the Chart show as below.
if FixVersion selected as FMR2001, the max x-axis Week value should be 1917.
if FixVersion selected as FMR2002, the max x-axis value Week should be 1915.
if FixVersion not selected or all selected, the x-axis value should be 1917.
After I created a summarized table. I am able to restrict it below the value. Now it is not cumulative total. that need to be worked out
Table = SUMMARIZE(FILTER(Tasks,Tasks[Type]="END"),Tasks[FixVersion],"Max week",max(Tasks[Week])) Count New = CALCULATE(COUNTROWS(Tasks), filter(Tasks,Tasks[Week]<=maxx(RELATEDTABLE('Table'),'Table'[Max week])))
Table is joined on the "fixed version" with Task Table.
yes, but I want to the cumulative data. I have a try, and still could not get the cumulative data.
Hi @hemingt ,
You can try to use following measure formula if it suitable for your requirement:
Acumulative Count = VAR __week = MAX ( 'Weeks'[Week] ) RETURN CALCULATE ( COUNTROWS ( 'Tasks' ), FILTER ( ALLSELECTED ( Tasks ), [Week] <= __week ), VALUES ( Tasks[Type] ) )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |