Populate columns in a table with rows filtered from two measures

[Anonymous]

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.

[Anonymous]

can u share sample data with expected output?

[Anonymous]

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]

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]

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

[Anonymous]

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]

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]

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]

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]

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]

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

[Anonymous · Accepted solution]

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.