Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello
I have a table named Tasks, and there are several columns, and two columns named 'Week' and 'FixVersion'
I want to firstly filter the table according to the column FixVersion with the condition Filter(Task, Task[FixVersion]=SELECTEDVALUE(Task[FixVersion])), then get the unquine with VALUES(Task[Week])
Do you know how to do? Thank you very much!
Solved! Go to Solution.
Hi @hemingt
Create two measures
Measure = CALCULATE(MAX(Tasks[Week]),FILTER(ALLEXCEPT(Tasks,Tasks[FixVersion]),[Type]="End")) Measure 2 = IF(MAX(Weeks[Week])<=[Measure],1,0)
Hi @hemingt
Values function will return a one-column table.
"Filter(Task, Task[FixVersion]=SELECTEDVALUE(Task[FixVersion]))"
What would you like with this function?
Is the following your wanted?
Hello @v-juanli-msft
Thank you very much for your reply.
I only want to the unique value of the column week based on your Filter. How can I get it?
if no need to filter FixVersion, it's very simple, just to use VALUS(Task[Week]).
but I also want to apply the filter according to the slice, Task[FixVersion]=SELECTEDVALUE(Task[FixVersion]), and then get the unqiue value of Week.
Hi @hemingt
As tested, the measure below can't display correctly in a table visual
Measure = VALUES('Table'[week])
Hello @v-juanli-msft
Thank you very much!
Here is my pbix file <https://1drv.ms/u/s!AsM9bO8zGUN6qzfNZxmmRlNzWq-O?e=DhTMyQ>
I want the restrict the x-axis value(Week) according to the slice(FixVersion).
in my demo, 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.
Can you help to have a look? Is it possible to solve?
Hi @hemingt
I can write a measure with hard code
Measure = IF(MAX(Tasks[FixVersion])="FMR2001",[Acumulative Count],IF(MAX(Weeks[Week])<=1915,[Acumulative Count]))
If you don't need this hard code, please tell me the logic of "restrict the x-axis value(Week) according to the slice(FixVersion)".
I did not want the hardcode.
The logic is I have many tasks belong to different projects. These tasks will start at certain Week number and end at certain week separately. I want to show such line chart, we can see how many tasks start at each week and end at each week. We also can slice the project to show tasks for each project.
Since the max Week may different for each project(task end week), I want to show x-axis week is the actual max week of the project.
If still something unclear, please let me know. Thank you!
Hi @hemingt
Create two measures
Measure = CALCULATE(MAX(Tasks[Week]),FILTER(ALLEXCEPT(Tasks,Tasks[FixVersion]),[Type]="End")) Measure 2 = IF(MAX(Weeks[Week])<=[Measure],1,0)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
84 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
64 | |
55 |