Forum Discussion
Post PartisanSlicer for text
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.
Post PartisanHi v-tianyich-msft
Thank you very much.
I had a missunderstanding.
I would immagine that I would do another table as written below.
Calclulating old and new version for every company and adding a slicer to filter
So if there are
Then the new table would be created like
From there I could add 2 slicers one for with old and new version
and if needed total
Regards
Heinrich
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
Hello
Fantastic work.
Would it be possible to have a slicer of total "Old Version" + "New Version".
Regards
Heinrich