Forum Discussion
Heinrich
Post Partisan
Post PartisanSlicer 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...
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
HeinrichPost Partisan
Post PartisanHello
I believe this can only work if I make a new table with the total of all users per company
than I can add this to the slicer.
Regards
Heinrich