Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Solved! Go to Solution.
can u share sample data with expected output?
Create below measure
Measure=Sumx(Table,IF(Table[Status] in {''pending'', "assigned", "fixed"} && Table[Resolve Date]=Today(),1,0))
Add above measure in visual level filter ans set measure is not 0.
If it resolve your problem mark it as solution.
Thanks,
Pravin
Please check your data if you see only 2 records have resoleve date= today() but their status is different than you r requiremn. hence it is producing 0 in measure.
If u want to create new table then go to modelling tab. click on new table and use calculateTable function and add filter in it with your requirement.
so is it not showing with required status and resolvedDate as today?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |