Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

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's avatar
    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.

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
2 years ago

Hello
Thank you.

I would like to have a slicer that gives me the total of all UPN's 


Therefore be able to select the range to show only companies that have 2 or more users
It would be great also to be able to select only new or only old version. But this can be done by having a second slicer.

 

I think I have to copy column A to a new table and count for every company old and new version 

and add it to the new table. So the table would look like

Column A = Company Name

Column B = Total New 

Column C = Total Old

 

How could I do that best?


Regards
Heinrich