Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
Anonymous
Not applicable

Populate columns in a table with rows filtered from two measures

I have two measures which count number of tickets. One measure counts the tickets closed in current day. Second tickets counts all tickets which are not closed but have specific status.

I now want to show all the cases in a table for above two measures. Any help will be great. Been trying for 2 days. But no breakthrough.
1 ACCEPTED SOLUTION
Anonymous
Not applicable

I was able to complete the task using your recommendation of calculate table.

I created one calculated table for resolved cases.
I created second calculated table for cases having specific status.
I than used Union to create a new table which added both the above tables. Thanks for the direction.

View solution in original post

11 REPLIES 11
Anonymous
Not applicable

can u share sample data with expected output?

Anonymous
Not applicable

TicketID         Status             Resolveddate        

1.                 Assigned.            

2.                   Fixed    

3.                Reviewed

4.                Reopened 

5.                Pending

6.                   New

7.                Resolved             12/17/2019

8.           Problem solved.      12/17/2019





I want a table to populate only cases which have status pending, assigned, fixed and resolved date as today.
Anonymous
Not applicable

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

Anonymous
Not applicable

This measure only produces the result 0. Hence when I apply this to the visual filter, all the records appear.
Anonymous
Not applicable

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.

Anonymous
Not applicable

The data I provided above was a sample data. My table has more than thousands of rows.

Let me try calculatetable and get back to you.
Anonymous
Not applicable

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.

Anonymous
Not applicable

New_table_name = CALCULATETABLE(Current_table_name,FILTER(Current_table_name,Current_table_name[Resolved_Date]=TODAY() && Current_table_name[Status] in {"Fixed","Resolved","Pending"}))
Anonymous
Not applicable

I tried calculatetable. Apparently && adds another level of filter. What I need is to show tickets with specific status AND cases which have resolveddate as today's date.
Anonymous
Not applicable

so is it not showing with required status and resolvedDate as today?

Anonymous
Not applicable

I was able to complete the task using your recommendation of calculate table.

I created one calculated table for resolved cases.
I created second calculated table for cases having specific status.
I than used Union to create a new table which added both the above tables. Thanks for the direction.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.