Forum Discussion
Need Help
Hi, I have 3 tables (PrimarySales,SecondarySales and Hierarchy). Territory Column is common among them and i have joined Hierarchy table with PrimarySales and Secondary sales table on common Key(Te...
Hi,
Many thanks for your reply ans yes same objective even i want to achieve which i rflecting in your image.However,request you to explain bit in detail for measure creation part.
The first measure, [
Sales 1 where S2 > 90%Returns the value 1 when the division of the primary sales by the secondary sales is greater than 0.9 (90%)
The second measure,
FinalSums these 1 values to obtain the total.
I've attached the sample PBIX file for you