Slicer for text

Hello I have a table that has following Data Column A = Company Column B = Old Version or New Version Column B is Text This table is displayed in Power BI Desktop I would like to do a sli...

Need Help

Show and Tell

Tips and Tricks

Tutorial Requests

Anonymous
2 years ago
Hi Heinrich ，

Try the following table expression:

Table 2 = ADDCOLUMNS('Table',"Old Version",CALCULATE(COUNTAX('Table','Table'[UPN]),FILTER(ALLEXCEPT('Table','Table'[Company]),[Version]="Old")), "New Version",CALCULATE(COUNTAX('Table','Table'[UPN]),FILTER(ALLEXCEPT('Table','Table'[Company]),[Version]="New")))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.