Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |