Forum Discussion
Ramachandran
Helper III
Helper IIIScatter chart - Show all the values
Hi, Someone assist me, I have two dimensions (Country and City) and two fact tables like Fact1 and Fact2. I'm trying to create scatter chart based on Fact1 (x) and Fact2 (y) values. but few of the ...
Hi Ramachandran ,
Here are the steps you can follow：
1. Create calculated column.
Column = var _1= CALCULATE(MAX('Fact2'[Y]),FILTER(ALL(Fact2),[Country]=EARLIER([Country]))) return DIVIDE([X],_1)Result:
2. Create measure.
flag = IF(MAX('Fact1'[Column])=BLANK(),BLANK(), "X"&"-"&FORMAT(MAX('Fact1'[Column]),"Percent"))3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ramachandran ,
Here are the steps you can follow：
1. Create calculated column.
Column =
var _1=
CALCULATE(MAX('Fact2'[Y]),FILTER(ALL(Fact2),[Country]=EARLIER([Country])))
return
DIVIDE([X],_1)
Result:
2. Create measure.
flag =
IF(MAX('Fact1'[Column])=BLANK(),BLANK(),
"X"&"-"&FORMAT(MAX('Fact1'[Column]),"Percent"))
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.