Forum Discussion
Solved
Countrows from Distinctcount from another column
Hi All, I'm trying to do a count of all values from one column... got that, not a problem. The problem is that I need my new count based on a distinct count from another column. For example col...
Good to know that you can solve your question.
Please accept the solution to others con use you.
Try with this measure:
Price =
IF (
SELECTEDVALUE ( Table1[B2B/B2C] ) = "B2B";
DISTINCTCOUNT ( Table1[S.O.Document] ) * 2,5;
DISTINCTCOUNT ( Table1[S.O.Document] ) * 1,65
)
You can made dinamically replacing the HardCoded Price with the AVG of the calculated column.
Regards
Victor
Victor, you are my HERO!!! That works PERFECTLY. I cannot thank you enough. THANK YOU THANK YOU!!!
Good to know that you can solve your question.
Please accept the solution to others con use you.