Report for Quantity of used Versions

[Heinrich]

Hello

First of all -- Merry Christmas and a Happy New Year --

I have 2 Tables 

- 1 Direct Query

- 1 Excel on SharePoint

The link/relationship  off both is the UPN

We are migrating from one Version to a higher one.

Would like to count the version of the software of an user (UPN) with the version less than 1.9

And count  the version of the software of an user (UPN) with the version higher less than 2

Imagine that this has to be done with 2 measures, right.

Do you have a solutation

Regards & thank you

JFM_12

[amitchandak]

@Heinrich , Assume the version is in a row context

Minx(Filter(all(Table), Table[Software] = max(Table[Software]) && Table[Version] > Max(Table[Version]) ), Table[Version])

[Heinrich]

Hello Amitchandak
Thank you very much.
I made a misstake sorry the value is displayed in text like

-- "Version Windows"

-- "Version Windows New"
The column is called
-- "Version of Application"

I should have the quantity per Version. Immagine that this could be done with 2 Measures right
and then add them in a table.

Actually the configuration and expected result is like this

Regards

JFM_12