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
Hi All,
Please help me in solving issue as attached sample data below.
In a pie chart for details selected status column and value field for distinct count of ID. SLicer also existed for date filter.
For example when I selected date range from jan1 to jan9 count should be 3 for closed status based on max date of each ID.
For example when I selected date range from jan1 to jan4 count should be 2 for closed status(for aa ID) and one opened status(for bb ID) based on max date of each ID.
I used calculated measure
Thanks
Praneeth.
Hi @Anonymous,
You can create a measure below:
Hi,
Still It showing incorrect result, what I was expecting is If we select datarange from jan1 to jan9 then count of ID's should be 3. How means for aa id max date status is closed, b id max date status is closed and cc id max date status is closed so in closed status it want show 3 count.
If we select datarange from jan1 to jan5 then count of ID's should be 2. How means for aa id max date status is closed, bb id max date staus is updated, then it should be show closed staus 1count and updated status 1 count.
Thanks
Praneeth
Hi @Anonymous,
You can modify the measure as below:
TicketCount = var t=SUMMARIZE(ALLSELECTED('Table1'),'Table1'[ID],"maxStatus",var d= max(Table1[Date])return CALCULATE(max(Table1[status]),Table1[Date]=d)) var s= max(Table1[status]) return COUNTROWS(FILTER(t,[maxStatus]=s))
For more information, see attached pbix.
Best Regards,
Qiuyun Yu
Hi All,
Please help me in solving issue as attached sample data below.
In a pie chart for details selected status column and value field for distinct count of ID. SLicer also existed for date filter.
For example when I selected date range from jan1 to jan9 count should be 3 for closed status based on max date of each ID.
For example when I selected date range from jan1 to jan4 count should be 2 for closed status(for aa ID) and one opened status(for bb ID) based on max date of each ID.
I used calculated measure
what I was expecting is If we select datarange from jan1 to jan9 then count of ID's should be 3. How means for aa id max date status is closed, b id max date status is closed and cc id max date status is closed so in closed status it want show 3 count.
If we select datarange from jan1 to jan5 then count of ID's should be 2. How means for aa id max date status is closed, bb id max date staus is updated, then it should be show closed staus 1count and updated status 1 count.
Thanks
Praneeth
Can any body solve this issue.
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 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |