Good Day , Please can I get some help with the following
I have the following cubevalue formula which counts the distinct suppliers in an area
=IFERROR(NUMBERVALUE(CUBEVALUE("ThisWorkbookDataModel","[Query1].[SOURCING SPLIT].[All].[LOCAL]","[Query1].[SOURCING REPORTING PRODUCT].[All].[KNITWEAR]","[Query1].[Gender].[All]","[Measures].[distinct count of Supplier Name]")),0)
The above formula returns an answer = 5
I would to filter and have a distinct count of only the suppliers where season orders were Greater than 0, the answer should then be 2
the measure for the season's orders is: [S'22 UNITS],
so I would like to add to the formula . . . [S'22 UNITS]>0 -- Hope this makes sense
I am stumped as to how to apply this condition and would appreciate any help please
Thanks
Joe
I have the following cubevalue formula which counts the distinct suppliers in an area
=IFERROR(NUMBERVALUE(CUBEVALUE("ThisWorkbookDataModel","[Query1].[SOURCING SPLIT].[All].[LOCAL]","[Query1].[SOURCING REPORTING PRODUCT].[All].[KNITWEAR]","[Query1].[Gender].[All]","[Measures].[distinct count of Supplier Name]")),0)
The above formula returns an answer = 5
I would to filter and have a distinct count of only the suppliers where season orders were Greater than 0, the answer should then be 2
the measure for the season's orders is: [S'22 UNITS],
so I would like to add to the formula . . . [S'22 UNITS]>0 -- Hope this makes sense
I am stumped as to how to apply this condition and would appreciate any help please
Thanks
Joe