Forum Discussion

Kevin_Gitonga's avatar
Kevin_Gitonga
Icon for Helper I rankHelper I
7 years ago
Solved

Aggregating Distinct Count measure and Aggregating IF measure

I have the following matrix table with the columns being products and the rows being the customer codes. What I want is to find the billings which is the distinct count of orders.I used the following...
General Comment
Need Help
Kevin_Gitonga's avatar
Kevin_Gitonga
Icon for Helper I rankHelper I
7 years ago

Ashish_MathurI tried the Golden point using the following formula and i'm gettting the correct total for the rows, but the total for the columns at the bottom is not correct, what could be the issue?

Golden Point = if(HASONEVALUE(Sales[ProductCode]),if(DISTINCTCOUNT(Sales[InvNumber])>=1,1,0),SUMX(SUMMARIZE(VALUES(Sales[ProductCode]),[ProductCode],"ABCD",if(DISTINCTCOUNT(Sales[InvNumber])>=1,1,0)),[ABCD]))


 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Try this simple measure for Golden Points

 

Golden Points = 1*[Billing]

 
Hope this helps.