Calculate table

Question

Hey guys I need your help,I have the following sample data:SubscriberIDCategoryAccountIDVNumberInstalldate482242107817322152361161140112/1/2017 0:000100107862022152361162190112/6/2017 0:000100107862222152361162170112/6/2017 0:000100107862922152361162090112/6/2017 0:000100107863022152361162380112/6/2017 0:000100107863122152361161160112/6/2017 0:00010010786374152361162120112/6/2017 0:00001010786384152361162160112/6/2017 0:000010107864048152361160260112/7/2017 0:001000107864822152361162140112/7/2017 0:000100&nbsp;(for one vnumber we can have several category types)I would like to have finall result table with the following columns:Vnumbe | category22 |&nbsp;category48 | category4 | if(category22=1 &amp;&amp;&nbsp;category48=1&nbsp;&amp;&amp;&nbsp;category4=1&nbsp; , Important, Regular)&nbsp;&nbsp;any tips.tricks?...

v-ljerr-msft · Accepted Answer

Hi&nbsp;Noak,
&nbsp;
If I understand you correctly, the formula below should work in your scenario.&nbsp;:smileyhappy:
Table =
ADDCOLUMNS (
    SUMMARIZE (
        Table1,
        Table1[VNumber],
        "22", COUNTROWS ( FILTER ( Table1, Table1[Category] = 22 ) )
            + 0,
        "48", COUNTROWS ( FILTER ( Table1, Table1[Category] = 48 ) )
            + 0,
        "4", COUNTROWS ( FILTER ( Table1, Table1[Category] = 4 ) )
            + 0
    ),
    "Type", IF ( [22] = 1 &amp;&amp; [48] = 1 &amp;&amp; [4] = 1, " Important", "Regular" )
)

&nbsp;
Regards

Forum Discussion

Related content

Direct Lake Model - Calculated Column/Tables

How to search specific word in table filter Calculations

Table Visual not Matching Calculated Visual

Directlake semantic model, calculated table

PowerBI - Matrix table, hide values used only for a visual calculation